The Teradata PT producer operators 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 the 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 more information, see Teradata® Parallel Transporter Reference, B035-2436. |
| ODBC Operator | Reads data from most ODBC-compliant data sources. Limitations:
For more information, see 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 the database and then process it before sending it to the data stream. For more information, see 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 more information, see 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 more information, see Teradata® Parallel Transporter Reference, B035-2436. |