Notes - Parallel Transporter
Teradata® Parallel Transporter Reference - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- IntelliFlex
- Lake
- Enterprise
- VMware
- Product
- Parallel Transporter
- Release Number
- 20.00
- Published
- October 2023
- ft:locale
- en-US
- ft:lastEdition
- 2023-12-06
- dita:mapPath
- mjn1691132485167.ditamap
- dita:ditavalPath
- obe1474387269547.ditaval
- dita:id
- ogv1478610452101
- lifecycle
- latest
- Product Category
- Teradata Tools and Utilities
- The Update operator cannot load data into temporal tables using the traditional MultiLoad protocol, because the database does not support it.
- If the USINGEXTENSION option is not specified, the job will continue and the job will be a non-temporal loading.
- The database allows only one VALIDTIME column when loading temporal tables in the Extended MultiLoad Protocol. The job will terminate with an error when there are multiple columns in the Teradata PT schema with the USINGEXTENSION option.
- The value for the USINGEXTENSION option is case-insensitive.
- If an USINGEXTENSION value is specified for non-temporal columns (like INTEGER, CHAR, etc), the Update operator will send the value to the database when the job is using the Extended MultiLoad Protocol. The database will validate the value and return an error if the value is invalid.
- If an USINGEXTENSION value is specified for non-temporal columns, the Update operator will ignore the value and will not send value to the database when the job is using the traditional MultiLoad protocol.