SQL Inserter Operator Capabilities - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

Figure 12 shows the SQL Inserter operator interface.

Figure 12: SQL Inserter Operator Interface