Other 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
  • One Update operator job can load up to 5 database tables for an import task. A single table is supported for a delete task.
  • By default, duplicate rows are not discarded by the 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 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 database 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 ErrorTable.
  • 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 database load slot when the job uses the traditional MultiLoad protocol. When the job uses the Extended MultiLoad Protocol, the Update operator requires one database load slot if the configurable database control field, MLOADXUtilityLimits, is set to FALSE. If MLOADXUtilityLimits is set to TRUE, the Update operator requires one database Extended MultiLoad Protocol slot when the job uses the Extended MultiLoad Protocol.