1.1 Teradata Parallel Transporter Introduction and Key Features

TPT introduction:

• TPT stands for Teradata Parallel Transporter.

• TPT is a object oriented client application.

• TPT uses and expands functionality of standalone extract and load utilities like Fastload , Multiload, FastExport and Tpump

• Teradata Parallel Transporter replaces earlier Teradata Warehouse Builder.

• Teradata PT can load data into, and export data from, any accessible database object in the

Teradata Database or other data store using Teradata PT operators or access modules.

• Multiple targets are possible in a single Teradata PT job. A data target or destination for a

Teradata PT job can be any of the following:

• Databases (both relational and non-relational)

• Database servers

• Data storage devices

• File objects, texts, and comma separated values (CSV)

Key Features of Teradata Parallel Transporter:

1. Process Specific Operators:

TPT jobs are run using OPERATORs. The operators are discrete object-oriented modules that perform specific extraction, loading, and updating data.

2. Access Modules:

Access Modules are software modules that give TPT access to various data stores.

3. A Parallel Execution environment

TPT can simultaneously load data from multiple and dissimilar data sources into, and extract data from, Teradata Database.

Also TPT can execute multiple instances of an operator to run multiple and concurrent loads and extracts and perform inline updating of data.

4. Use of Data Streams:

Teradata PT distributes data into data streams shared with multiple instances of operators to scale up data parallelism.

Data streaming eliminates the need for intermediate data storage: data is streamed through the process without being written to disk.

5. A Single SQL like scripting language:

The old stand alone utilities like mload, fastload etc had their own scripting language which is specific to that utility.

With TPT we can have single script language to specify extraction, loading and updating operations.

6. Application Programming Interfaces (API)

Apart from scripting we can invoke TPT using open API's also.

Using the Teradata PT open APIs allows third-party applications to execute Teradata PT operators directly.

7. TPT wizard:

We also get a tool called TPT wizard which can be used to generate simple TPT scripts.