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 Stream operator job can load up to 127 Teradata tables or views.
  • Only the Teradata SQL INSERT, UPDATE, DELETE, UPSERT, MERGE, and EXECUTE statements are supported. Any other Teradata SQL statements are not supported.
  • Data can be loaded into empty or populated Teradata tables.
  • By default, duplicate rows are not discarded by the Stream operator for SET tables. Duplicate rows are inserted into the 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 error table.
  • Duplicate rows are not discarded by the Stream operator 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.
  • Row hash level locking is used during the job. The job does not lock the target tables.
  • For updates, a record cannot change the value of the primary index of a row, but reflexive updates of other columns are allowed. A reflexive update of a column computes the new value as the result of an expression that involves the current value of one or more columns.
  • The atomic UPSERT feature cannot have any of the following syntax or characteristics:
    • INSERT-SELECT
    • UPDATE-WHERE-CURRENT
    • UPDATE-FROM
    • UPDATE-WHERE SUBQUERIES
    • UPDATE-PRIMARY INDEX
    • UPDATE or INSERT that could cause a trigger to be fired
    • UPDATE or INSERT that could cause a join or hash index to be updated
  • The target tables cannot be rolled back after the job is complete.
  • A DML group cannot use the Array Support feature if the DML group has multiple DML statements. The exception is atomic UPSERT statement. Atomic UPSERT statement can use the Array Support feature.
  • A job with multiple DML groups and serialize on cannot use the Array Support feature. A job with a single DML group and serialize on can use the Array Support feature if the DML group contains a single DML statement or an atomic UPSERT statement.
  • The Stream operator does not support the TPump's Wildcard INSERT feature.
  • The Stream operator does not require a Teradata Database load slot.