16.20 - Producer Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

The Teradata PT producer operators in this section 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 Teradata 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:

  • Can read a specific file or can be used to scan a directory.
  • Interfaces with all Teradata PT supported access modules.
  • Reads files and tables from Hadoop.

Limitations:

  • Cannot read data from ODBC-compliant data sources.
  • Cannot read ZIP and GZIP files from a Hadoop/HDFS data source.

For details, see Teradata Parallel Transporter Reference (B035-2436).

ODBC Operator Reads data from most ODBC-compliant data sources.

Limitations:

  • Cannot interface with access modules.

For details, see the 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 Teradata Database and then process it before sending it to the data stream.

For details, see the 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 details, see the 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 details, see the Teradata Parallel Transporter Reference (B035-2436).