The Teradata PT producer operators in this section read data from a 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 database tables. For more 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 database:
Operator | Description |
---|---|
Export Operator | Extracts large volumes of data from a database at high speed. Function is similar to the standalone Teradata FastExport utility. Features:
Limitations:
For more information, see Teradata® Parallel Transporter Reference, B035-2436. |
SQL Selector Operator | Submits a single SQL SELECT statement to a 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 more information, see Teradata® Parallel Transporter Reference, B035-2436. |