15.00 - Operation - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

Parallel Transporter
Programming Reference


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.