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.
Figure 15 shows the Stream operator interface.
Figure 15: Stream Operator Interface