Notes - Parallel Transporter
Teradata Parallel Transporter Reference
- Product
- Parallel Transporter
- Release Number
- 16.10
- Published
- July 2017
- Language
- English (United States)
- Last Update
- 2018-06-28
- dita:mapPath
- egk1499705348414.ditamap
- dita:ditavalPath
- Audience_PDF_include.ditaval
- dita:id
- B035-2436
- lifecycle
- previous
- Product Category
- Teradata Tools and Utilities
- The Update operator cannot load data into temporal tables using the traditional MultiLoad protocol, because the Teradata 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 Teradata Database allows only one VALIDTIME column when loading temporal tables in the extended MultiLoad protocol. The job will terminate with a Teradata Database 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 Teradata Database when the job is using the extended MultiLoad protocol. The Teradata Database will validate the value and return a Teradata Database 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 Teradata Database when the job is using the traditional MultiLoad protocol.