Producer Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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:
  • Allows use of multiple parallel instances.
  • For a sorted answer set, redistribution of the rows occurs over the BYNET. This allows for easy recombination of the rows and data blocks when they are sent to the client in sorted order.
Limitations:
  • Cannot be used to retrieve data in TEXT mode and write it to target files in the TEXT or VARTEXT (delimited) format. Use SQL Selector for this where possible.
  • A sorted answer set requires that only a single instance of the Export operator can be used. Specifying ORDER BY in the SELECT statement and multiple Export operator instances results in an error.

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:
  • Use to retrieve data in TEXT mode and write it to target files in the TEXT or VARTEXT (delimited) format.
  • Can retrieve LOB, JSON and XML data from a database.
Limitations:
  • Much slower than Export operator.

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.