15.10 - Operator Summary - Parallel Transporter

Teradata Parallel Transporter User Guide

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

Operator Summary

Table 2 summarizes the function, type, and purpose of the Teradata PT operators.

For detailed information about operators, see Teradata Parallel Transporter Reference.

 

Table 2: Operator Summary 

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 Teradata 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

    Note: Avoid using the keywords TYPE CONSUMER, TYPE PRODUCER, TYPE FILTER, OR TYPE STANDALONE in any operator definition.

    Teradata PT now supports Online Archive. For more information, see the Database Administration book, available from http://www.info.teradata.com/.