Multiple parallel instances can be used to improve the performance of the load. Multiple instances of the Load operator can be run in a job, but all of them load data into the same table.
During a Load job, the Load operator inserts the data from each record it receives from the data streams into one row of the target table on Teradata Database. Because Teradata PT can filter out rows based on criteria in the script, some input rows may not be loaded.
The Load operator does not support Update, Select, and Delete operations on the target table. The Load operator only support Insert operations.