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