SQL Inserter Operator Capabilities - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
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 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 database table. 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 database deadlock 2631 error. To avoid this error, do not use multiple sessions with the TPT SQL Inserter operator.
  • If multiple sessions are used and the data accesses the same row-level lock on the database, the job could result in a hang. To avoid a hang, do not use multiple sessions with the TPT SQL Inserter operator. Use only one session.

The following figure shows the SQL Inserter operator interface.