16.10 - Notes - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)
  • 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.