16.10 - Other 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)
  • One Update operator job can load up to 5 Teradata tables for an import task. A single table is supported for a delete task.
  • By default, duplicate rows are not discarded by the Teradata Database for SET tables. Duplicate rows are inserted into the application phase error table. Use the DML option, "IGNORE DUPLICATE ROWS," to override the default if you do not want the duplicate rows to be inserted into the application phase error table.
  • Duplicate rows are not discarded by the Teradata Database for MULTISET tables; they are inserted into the target tables. The DML options, "MARK DUPLICATE ROWS" and "IGNORE DUPLICATE ROWS" cannot override this behavior. Duplicate rows are allowed for MULTISET tables.
  • Only the Teradata SQL INSERT, UPDATE, DELETE, and UPSERT statements are supported; any other Teradata SQL statements are not supported.
  • Data can be loaded into empty or populated Teradata tables.
  • A delete task cannot be used on a view.
  • The target tables are locked until the application phase is complete.
  • The target tables cannot have column names that are the same as the error table column names, because the application phase error table includes a mirror image of the target table, preceded by the error information. For more information on the application error table, see ***resolve--this is a section in this document "Update Operator Errors"***.
  • You can pause the job for an import task. You cannot pause the job for a delete task.
  • The target tables cannot be rolled back after the application phase is complete.
  • The Update operator requires one Teradata Database load slot when the job uses the traditional MultiLoad protocol. When the job uses the extended MultiLoad protocol, the Update operator requires one Teradata Database load slot if the configurable Teradata Database control field, MLOADXUtilityLimits, is set to FALSE. If MLOADXUtilityLimits is set to TRUE, the Update operator requires one Teradata Database extended MultiLoad protocol slot when the job uses the extended MultiLoad protocol.