Stream Operator Capabilities | Teradata Parallel Transporter - Stream Operator Capabilities - 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

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.