Producer Operators
The Teradata PT producer operators in this section read data from a Teradata Database and write it to the data stream.
The Teradata PT job script invokes a producer operator, which employs the user-specified SQL SELECT statement to access Teradata Database tables. For further information on using APPLY/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 extracting data from a Teradata Database:
Operator |
Description |
Export Operator |
Extracts large volumes of data from a Teradata Database at high speed. Function is similar to the standalone Teradata FastExport utility. Features: Limitations: For details, see Teradata Parallel Transporter Reference. |
SQL Selector Operator |
Submits a single SQL SELECT statement to the Teradata Database to retrieve data from a table. Features: Limitations: Teradata strongly recommends that you specify XMLSERIALIZE on selected XML columns so that the byte-order-mark (BOM) matches the XML encoding when using the client UTF-16 character set. For details, see Teradata Parallel Transporter Reference. |