Restrictions and Limitations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Restrictions and Limitations

This section describes the restrictions and limitations when using the Stream operator.

Data Types

The job cannot load these data types:

  • LOB
  • JSON
  • XML
  • ST_Geometry
  • UDT data can be loaded in its external type format.

    Error Table

    Two jobs loading different tables with different table definition cannot use the same error table.

    Other Notes

  • 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.