Functional Description of the Update Operator - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

During an Update job, the Update operator loads database tables. Each instance retrieves rows from the Teradata PT data streams and sends them to the database. Multiple parallel instances can be used to improve the performance of the update.

The Update operator reads a data block only once. The operator reads rows from a data stream, writes that data to a buffer, then sends that buffer of data across sessions to the available AMPs.

This process is dependent on all changes to tables being keyed on the primary index. Thus, all transactions must be primary index operations when using the Update operator. An exception to this rule is the use of the Delete Task. For more information, see Delete Task Option.