Operators:

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

  • Producer operator
  • consumer operator
  • Filter operator
  • Standalone operator

a)Producer operator

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

OperatorDescription
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 platforms.

  2Fast load in mod adaptor

2Multi load in mod adaptor  

b)Consumer operator

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

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

 

Inclined to build a profession as Teradata DBA Developer? Then here is the blog post on, explore Teradata DBA Training

 

PT OperatorMax Tables
Load1    
Update5
Stream127
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

  Filter operator  

d)Standalone operator:

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

2The below stand lone operators are available

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

 

Standalone Operator

  Standalone Operator  

Object Definition

  • Define Job
  • Define Schema
  • Define operator
  • Define DBMS
  • Define Table
  • 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<operator>

Schema<name>(or)*

 

  Attributes  

 

Example

Type load

Schema se- party

Attribute

(

  ----

----

)  

 

Sessions and Instance

Sessions Take multiple connections to the script while processing

Generally fast load, multi-load, TPUMP, and fast export use session.

Instance is used by the operators to process the data gallery

Ex: min sessions=2;

Max sessions=8;  

Instance

Syntax operator:[NUMBER]

EX: Load- party[4]      

For an in-depth knowledge, click on below