15.10 - Producer Operators - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Producer Operators

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” 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 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.

    ODBC Operator

    Reads data from most ODBC-compliant data sources.

    Limitations:

  • Cannot interface with access modules.
  • For details, see the Teradata Parallel Transporter Reference.

    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.

    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.

    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.