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 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 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 (B035-2436). |
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 (B035-2436). |