You can use the Stream system operator to perform high-speed parallel inserts to empty or existing Teradata tables without locking target tables.
You can perform update, upsert, and delete operations after you define a primary key in the target table. The Secure Agent does not retain the primary key information of a Teradata table during metadata import. You must therefore select the target columns in the
Update Columns
field in the target properties. The target columns serve as a key when you run an update, upsert, or delete operation.
You can maintain current and accurate data for immediate decision making. The Stream system operator uses macros to modify tables. The Stream system operator creates macros before Teradata PT API begins loading data and removes them from the database after Teradata PT API loads all rows to the target. If you do not specify a macro database, Teradata PT API stores the macros in the log database.
Error Limit for the Stream Operator
Teradata PT API terminates the Stream system operator job after it reaches the maximum number of records that can be stored in the error table.
The error limit is approximate because the Stream operator sends multiple rows of data at a time to the Teradata table. By the time Teradata PT API processes the message that indicates that the error limit has been exceeded, it might have loaded more records into the error table than the number specified in the error limit.
By default, the error limit value is unlimited. The error limit applies to each instance of the Stream system operator.
ASK INFAPreview
