The main task of DDL operator is to send SQL statements to the 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 to another. 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.
The following figure shows the DDL operator interface.