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.
