Teradata Parallel Transporter
Teradata Parallel Transporter (TPT) is a data loading utility sold by the software company Teradata, typically used in data warehousing. It combines the functionality of Teradata FastLoad, MultiLoad, FastExport, and TPump.
TPT is a parallel load environment, which provides access to data sources from a single interface using a single SQL-like scripting language and from a published application programming interface (API). Multiple files can be loaded using a single script. The utility allows load balancing of the workload across multiple CPUs, which is designed to reduce bottlenecks in the data loading process.
Each user can create a job (that is, a string of TPT commands) that allows them to perform operations, such as heterogeneous data access, data integrity checks, data merging, and data loads in batch or interactive.
It was designed to use the different Teradata data loading and unloading utilities under a single infrastructure. Based on the protocols of fastload, multiload, tpump and fastexport, new "operators" were developed called Load, Update, Stream and Export respectively. Other operators include Selector, Inserter, Dataconnector, and ODBC.
Executing the script:
tbuild –f TPT_Scriptname.tpt
Whenever we execute TPT there is a .out file created which is like a log file for TPT. You cannot read contents of .out file by cat or more or any other UNIX command if running on UNIX or in Notepad or any other Text Editor. To view the file use below command:
tlogview –l TPT_Script.out
- "Teradata Parallel Transporter TPT – Basics , Example and Syntax | Teradata SQL Tutorial". usefulfreetips.com. Retrieved 2016-01-02.