Purpose - Parallel Transporter

Teradata® Parallel Transporter Reference

Parallel Transporter
Release Number
February 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The DEFINE OPERATOR statement defines a Teradata PT operator object. Operator objects identify the Teradata PT operators, that is, the job components that actually perform the movement of data from sources to targets, as well as other supporting job functions.

Teradata PT provides a set of standard (or predefined) operators. These operators can be identified by means of the TYPE keyword as follows:

TYPE Definition
DATACONNECTOR PRODUCER DataConnector operator used as a producer
DATACONNECTOR CONSUMER DataConnector operator used as a consumer
DDL DDL operator
EXPORT Export operator
FASTEXPORT OUTMOD FastExport OUTMOD Adapter operator
FASTLOAD INMOD FastLoad INMOD Adapter operator
INSERTER SQL Inserter operator
LOAD Load operator
MULTILOAD INMOD MultiLoad INMOD Adapter operator
ODBC ODBC operator
OS COMMAND OS Command operator
SCHEMAMAPPER Schema Mapping operator
SELECTOR SQL Selector operator
STREAM Stream operator
UPDATE Update operator

For details on the capabilities, attributes, and required syntax for each of these standard Teradata PT operators, see the corresponding topics in this document.

Teradata PT allows you to define operators using a more generic use of the TYPE keyword. For example, those who wish to create their own operators must define TYPE using the following TYPE specifications:

TYPE Definition
PRODUCER Operators that produce a data stream from data received from a data source.
CONSUMER Operators that consume data from a data stream and load it into a data target.
FILTER Operators that filter data moving between a data source and a data target.
STANDALONE Operators that work alone without receiving data from, or sending data to, other operators.

For details on creating customer-coded operators Teradata Parallel Transporter Operator Programmer Guide (B035-2516).

Teradata PT has internal knowledge of its standard operators, such as the operator library file and its message catalog file, so that these properties need not be specified in the DEFINE OPERATOR statement.

Teradata PT has no such knowledge about a customer-coded operator, so the former must be specified via the EXTERNAL NAME keyword phrase and the latter via the MSGCATALOG attribute, if a standard name is not used. See MSGCATALOG “catalog-name” in Deprecated Syntax.