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 can log one or more SQL sessions. Multiple, parallel instances can be used to improve the performance of loading data records into a target table on Teradata Database. The target table can be an empty table or a table with existing data in it.
The following figure shows the SQL Inserter operator interface.