Social Icons

TPT

TeradataWiki-Teradata Utilities 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.
TERADATA TPT
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.
TERADATA TPT

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

3 comments:

  1. Please update TPT with one example...

    ReplyDelete
  2. Please provide an example of TPT & how to run the TPT

    ReplyDelete
    Replies
    1. Hi, Thanks for Visiting.. We are working on it. You can follow this site via facebook/twitter/gplus/linkedin for more updates.

      Delete