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 Teradata 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 Teradata 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.
Stream Operator Interface