Group Discounts available for 3+ students and Corporate Clients

Working with Operators in TeraData


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

Operator Description
EXPORT Fast export utility to export data to file form tables.
SQL Selector Select data form tera data tables with SQL Sessions
Data connector Reads data from external files.
ODBC Operator Extract 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

Operator Description
Load Operator Implement Fast Load  functionality, loading to empty tables
Update Operator Implement multi load functionality loading to 5 tables
Stream Operator Implement TPUMP Protocal continuous loading data to tera data tables
SQL Inserter Inserter data into tera data tables, with SQL session
Data connector Writes data to an external files to access module


PT Operator Max Tables
Load 1



Update 5
Stream 127
SQL Inserter 1

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

Operator Description
DDL Operator Create indexes, tables, drop tables, delete table, replace, rename , macro, views, name etc operations
Update operator Use when performing delete task and there is no data need for the delete SQL Request
OS Command It 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]




“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Working with Operators in TeraData"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6