Group Discounts available for 3+ students and Corporate Clients

Working with Operators in TeraData

Operators:

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

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

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

 

Screenshot_21

 

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

OperatorDescription
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

Screenshot_22

 

Screenshot_23

 

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

Schema<name>(or)*

 

Screenshot_24

 

Example

Type load

Schema se- party

Attribute

(

 

—-

—-

)

 

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;

 

Instance

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 info@tekslate.com, 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 *

    Support


    Please Enter Your Details and Query.
    Three + 6