TPT Performs operations that are extract, load, transform etc to the below 4 operations

  1. Producer operator
  2. consumer operator
  3. Filter operator
  4. Standalone operator


a)Producer operator

Reads data source and writes to data streams the below operatore are available in producer operator

EXPORTFast export utility to export data to file form tables.
SQL SelectorSelect data form tera data tables with SQL Sessions
Data connectorReads data from external files.
ODBC OperatorExtract data from any ODBC Provider on windows, unix, MVS plat forms.


2Fast load inmod adaptor

2Multi load inmod adaptor


b)Consumer operator

Reads data from data streams and writes to a tera data data base the below sub operators are available

Load OperatorImplement Fast Load  functionality, loading to empty tables
Update OperatorImplement multi load functionality loading to 5 tables
Stream OperatorImplement TPUMP Protocal continuous loading data to tera data tables
SQL InserterInserter data into tera data tables, with SQL session
Data connectorWrites data to an external files to access module


PT OperatorMax Tables



SQL Inserter1

2Fast export out mod adaptor


c)Filter operator

Read and write data from and to stream and perform data transformation function such as selection, validation, conjoins




d)Standalone operator:

2Standalone processing that does not in value sending(or)Receiving to and from the data stream it does not operate on data stream.

2The below stand lone operators are available

DDL OperatorCreate indexes, tables, drop tables, delete table, replace, rename , macro, views, name etc operations
Update operatorUse when performing delete task and there is no data need for the delete SQL Request
OS CommandIt execute os command on the client system





Object Definition

  1. Define Job
  2. Define Schema
  3. Define operator
  4. Define DBMS
  5. Define Table
  6. Define table ser 


Define operator

Takes operator, operator attributes


Define schema

2Define data structure the data an operator will process

2Unique structure for every object


Important command line structure

Tbulid  - Runs tera data PT Job parallel transporter

Tlog view - 

View the content of log file produced for running a tera data parallel transporter job


Operator syntax - 







Type load

Schema se- party








Sessions and Instance

  1. Sessions Takes multiple connection to the script while processing
  2. Generally fast load, multi load, TPUMP and fast export use session.
  3. Instance are used by the operators to process the data prallery

Ex: min sessions=2;

Max sessions=8;



Syntax operator:[NUMBER]

EX: Load- party[4]