16.10 - Operation - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

Parallel Transporter
May 2017
Programming Reference
The Teradata PT infrastructure provides a simple, declarative SQL-like scripting language for specifying the following functions:
  • Load, export, and update processing
  • Data source and destination
  • Transformation and filtering functions
  • Number of parallel instances of the load, export, update, and transformation operators

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

  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.

The following figure illustrates the main components of the Teradata PT infrastructure.

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 load/export operators can call to provide enhanced processing functions on the following items:
  • 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.