Operation - Parallel Transporter

The Teradata PT infrastructure provides a simple, declarative SQL-like scripting language for specifying:

The load, export, and update processing

The data source and destination

Any transformation and filtering functions

The number of parallel instances of the load, export, update, and transformation operators

In response to a Teradata PT job script, the Teradata PT infrastructure:

1 Parses the statements in the Teradata PT job script.

2 Initializes its internal components.

3 Creates, optimizes, and executes a parallel plan for completing the Teradata PT job by:

Creating instances of the required operator objects

Creating a network of data streams which interconnect the operator instances

Coordinating the execution of the operators

4 Coordinates checkpoint and restart processing.

5 Terminates the processing environment.

Figure 1 illustrates the main components of the Teradata PT infrastructure.

Figure 1: Teradata PT Infrastructure

The INMOD and OUTMOD routines are custom software modules that interface with Teradata standalone load and export utilities. These are user exit routines that the load/export operators can call to provide enhanced processing functions on:

Input records before they are sent to the Teradata Database (INMOD routines)

Output records before they are sent to the client system (OUTMOD routines)

Adapter operators support these routines by allowing you to use the utilities within the Teradata PT infrastructure.