Teradata Parallel Transporter (TPT)

The Teradata Parallel Transport (TPT) utility is combination of BTEQ, FastLoad, MultiLoad, Tpump, and FastExport utilities. So TPT can perform

• Insert data to tables
• Export data from tables
• Update tables

TPT works around the concept of Operators and Data Streams.

TPT

In the following diagram showing you mainly three components.

1. Producer or READ Operator
2. Filter Operator or TRANSFORM Operator 
3. Consumer Operator or WRITE Operator

The Producer Operator performs read the Queues, Files, Relational Databases, and Non-Relational Sources.
The Filter Operators Transforms data from INMODs, WHERE Clauses, APPLY Filters, and User-Defined functions.
The Consumer Operator performs INSERTS (Load), Updates, SQL Inserts, and Tpump like Streams.

How to Run a TPT Script

The easiest way to run a TPT script is to use the TBuild utility. You first create your script and then run TBuild, passing
TBuild the script name to run.

In the below example just create a sample script called Scriptname.txt(this is not complete script)
Then run by using TBuild –f command.

1) Create a script

DEFINE JOB CREATE_SOURCE_EMP_TABLE

                          (

DEFINE OPERATOR DDL OPERATOR 

DESCRIPTION 'TPT DDL OPERATOR'

                 TYPE DDL

             ATTRIBUTES

                        (

VARCHAR TDPID = 'LOCALTD',

VARCHAR USERNAME ='DBC', 

VARCHAR PASSWORD ='DBC',

);

2) Using the command prompt run TBuild command

   TBuild -f C:\Temp\Scriptname.txt