Notes - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
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.