Operation - Parallel Transporter

Teradata® Parallel Transporter Operator Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
igj1608578346674.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2435
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.



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 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.