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 and the section on APPLY in Teradata Parallel Transporter Reference (B035-2436).
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 (B035-2436). |
ODBC Operator | Reads data from most ODBC-compliant data sources. Limitations:
For details, see the Teradata Parallel Transporter Reference (B035-2436). |
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 (B035-2436). |
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 (B035-2436). |
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 (B035-2436). |