Stream Operator Capabilities - 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

The Stream operator, a consumer operator, emulates the Teradata TPump utility to perform high-speed parallel Inserts, Updates, Deletes, and Upserts in a near-real-time to one or more empty or preexisting database tables without locking target tables.

Row level locking, as used in the Stream operator’s SQL transactions, allows load operations in the background during normal system use.

The Stream operator instances can update up to 127 tables on the database. Multiple parallel instances can be used to improve the performance of the update. For performance tuning in the Stream operator, see Teradata PT Utility Commands.

The following figure shows the Stream operator interface.