Operator Summary - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

The following table summarizes the function, type, and purpose of the Teradata PT operators.

For more information about operators, see Teradata® Parallel Transporter Reference, B035-2436.

Teradata PT Operator Needed TYPE Definition Action Standalone Equivalent
DataConnector operator as a consumer TYPE DATACONNECTOR CONSUMER
  • Writes to flat files
  • Interfaces with access modules
  • Writes to Hadoop files and tables
Data Connector
DataConnector operator as a producer TYPE DATACONNECTOR PRODUCER
  • Reads flat files
  • Interfaces with access modules
  • Reads from Hadoop files and tables
Data Connector
DDL operator TYPE DDL Executes various DDL, DML, and DCL statements DDL statements in utility scripts
Export operator TYPE EXPORT Reads bulk data from a database FastExport
FastLoad INMOD Adapter TYPE FASTLOAD INMOD Processes data prior to writing to a data stream FastLoad INMOD
FastExport OUTMOD Adapter operator TYPE FASTEXPORT OUTMOD Processes data after an export FastExport OUTMOD
Load operator TYPE LOAD Loads empty tables FastLoad
MultiLoad INMOD Adapter operator TYPE MULTILOAD INMOD Processes data prior to updates MultiLoad INMOD
MultiLoad INMOD Adapter operator TYPE MULTILOAD INMOD FILTER Filters and cleans input data MultiLoad INMOD
ODBC operator TYPE ODBC Exports data from ODBC-compliant data sources OLE DB Access Module
OS Command operator TYPE OS COMMAND Executes OS commands in a job OS FastLoad command
SQL Inserter operator TYPE INSERTER Inserts data using SQL protocol BTEQ
SQL Schema Mapping operator TYPE SCHEMAMAPPER Verifies that the schema definition correctly describes the input data and allows data to be displayed in various formats for debugging purposes n/a
SQL Selector operator TYPE SELECTOR Exports data using SQL protocol BTEQ
Stream operator TYPE STREAM Performs continuous updates, deletes, and inserts into multiple tables TPump
Update operator TYPE UPDATE Performs bulk updates, deletes, and inserts MultiLoad
Update operator as a standalone TYPE UPDATE

DeleteTask attribute

Deletes rows from a single table with a DELETE Task MultiLoad DELETE
Avoid using the keywords TYPE CONSUMER, TYPE PRODUCER, TYPE FILTER, OR TYPE STANDALONE in any operator definition.