Producer Operators
The Teradata PT producer operators in this section read data from an external data source and place it in the data stream.
The Teradata PT job script invokes a producer operator using a SELECT statement within an APPLY statement. For further information on using SELECT to specify a producer operator, see “Coding the APPLY Statement” on page 64 and the section on APPLY in Teradata Parallel Transporter Reference.
The following table briefly describes and compares the function of each Teradata PT operator that can be used as a producer when moving data from an external source into Teradata Database:
Operator |
Description |
Operators that Read Data from External Sources |
|
DataConnector Operator |
Reads flat files from an external data source. Functions similarly to the standalone Teradata DataConnector utility. Features: Limitations: For details, see Teradata Parallel Transporter Reference. |
ODBC Operator |
Reads data from most ODBC-compliant data sources. Limitations: For details, see the Teradata Parallel Transporter Reference. |
Operators that Read and Modify Data from External Sources |
|
FastExport OUTMOD Adapter Operator |
Uses FastExport OUTMOD routines to read data from Teradata Database and then process it before sending it to the data stream. For details, see the Teradata Parallel Transporter Reference. |
FastLoad INMOD Adapter Operator |
Uses FastLoad INMOD routines to read data from external files and then process it before sending it to the data stream. For details, see the Teradata Parallel Transporter Reference. |
MultiLoad INMOD Adapter Operator |
Uses MultiLoad INMOD routines to read data from external files and then process it before sending it to the data stream. For details, see the Teradata Parallel Transporter Reference. |