Choosing operators for use in a job script is based on the type of data source, the characteristics of the target tables, and the specific operations to be performed. Teradata PT scripts can contain one or more of the following operator types.
- Producer operators “produce” data streams after reading data from data sources.
- Consumer operators “consume” data from data streams and write it to target tables or files.
- Filter operators read data from input data streams, perform operations on the data or filter it, and write it to output data streams. Filter operators are optional.
- Standalone operators issue Teradata SQL statements or host operating system commands to set up or clean up jobs; they do not read from, or write to, the data stream.
The following locations contain additional information about Teradata PT operators:
- For details about operator attributes and syntax, see Teradata Parallel Transporter Reference (B035-2436).
- For information about operator capabilities, see Teradata Parallel Transporter Reference (B035-2436).
- For examples of using operators to accomplish specific tasks, see Moving External Data into Teradata Database, Moving Data from Teradata Database to an External Target, and Moving Data within the Teradata Database Environment.