SQL Inserter Operator Capabilities
The SQL Inserter operator is a consumer operator inserts the data into a Teradata Database table. An SQL Inserter operation is similar in function to a BTEQ import operation.
The SQL Inserter operator supports multiple instances and each instance logs on as a single SQL session. To take advantage of the parallel processing of Teradata PT, users can specify multiple instances, which means multiple session, in order to insert data records simultaneously into a target table on Teradata Database. A target table can be an empty table or a table with existing data in it.
Figure 12 shows the SQL Inserter operator interface.
Figure 12: SQL Inserter Operator Interface