DDL Operator Capabilities - Parallel Transporter

Teradata Parallel Transporter Reference

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

DDL Operator Capabilities

The main task of DDL operator is to send SQL statements to Teradata Database to perform setup operations prior to executing load or export tasks.

The DDL operator is frequently used to create or drop error tables or indexes required by Teradata PT operators that will perform the main job tasks. You can, for example submit an INSERT…SELECT statement using the DDL operator to move data from one table in Teradata Database to another table in Teradata Database. The DDL operator is also used to perform mini-batch loading tasks.

The DDL operator is neither a producer nor consumer operator. It does not retrieve data records from the Teradata PT data stream nor put records into the data stream. An APPLY statement is used in a Teradata PT job script in which a DDL operator is defined.

Note: Because conditions in the database may change between uses of a particular job script, you should always evaluate the need to add or change the DDL operator in the script before running a particular Teradata PT job.

Figure 1 shows the DDL operator interface.

Figure 1: DDL Operator Interface