Defining Producer Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.00
Published
August 31, 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
zae1544831938751.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Producer operators “produce” a data stream after reading data from a database or an external data store. Then they write the data into the data stream for further processing by consumer or filter operators.



A Teradata PT job script allows as many producer operators as data sources, as long as the output schema is the same; or you can use a single producer. The producer extracts data from the source and places it into the data stream, where other operators can use it.

Following is a list of Teradata PT producer operators:

Operator Description
Produces Data from a Database:
Export The Export operator extracts data from database tables and writes it to the data stream. The Export operator functions in a way similar to the standalone FastExport utility protocol.
SQL Selector Selects data from database tables using SQL sessions. The only producer operator that can handle LOB, JSON, and XML data.
Produces Data from a Non-Database Data Source:
DataConnector (producer) The DataConnector operator accesses files either directly or through an access module, and then writes it to the data stream.

The DataConnector operator can also read data from files and tables in Hadoop.

ODBC The ODBC operator extracts data from any ODBC provider, such as Oracle or SQL Server on Windows, UNIX, and z/OS platforms, and then writes it to the data stream.
Produces and Processes Data from a Non-Database Data Source:
FastLoad INMOD Adapter The FastLoad INMOD adapter uses FastLoad INMOD routines to read and preprocess input data from flat files, and then places it in the data stream.
MultiLoad INMOD Adapter The MultiLoad INMOD adapter uses MultiLoad INMOD routines to read and preprocess input data from flat files, and then places it in the data stream.