15.10 - Defining Operators - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.
  • Note: The following locations contain additional information about Teradata PT operators:

    For details about operator attributes and syntax, see Teradata Parallel Transporter Reference.

    For information about operator capabilities, see Teradata Parallel Transporter Reference.

    For examples of using operators to accomplish specific tasks, see “Chapter 5 Moving External Data into Teradata Database,”“Chapter 6 Moving Data from Teradata Database to an External Target,”and “Chapter 7 Moving Data within the Teradata Database Environment.”