16.10 - SQL Inserter Operator Capabilities - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.

If multiple sessions are used and the data has duplicate primary index values, this could result in a potential Teradata Database deadlock 2631 error. To avoid this error, do not use multiple sessions with the TPT SQL Inserter operator.

The following figure shows the SQL Inserter operator interface.

SQL Inserter Operator Interface