Parallel Execution Plan - 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

As shown in the figure in Operation, the Teradata PT processor is the nucleus of the Teradata PT infrastructure. All user requests for importing, exporting, or updating data are submitted to the Teradata PT processor as a job script using high-level, nonprocedural Teradata PT statements. See the Teradata® Parallel Transporter Reference, B035-2436 for a description of the Teradata PT statements.

The Teradata PT processor parses the statements in the job script, validates their syntax, and creates instances of the specified operators, connected by data streams and a plan for coordinating their execution, called a parallel execution plan. During job execution, the Teradata PT processor performs the following tasks:

  1. Uses the Teradata PT metadata to establish the data streams between operators
  2. Validates the user’s access privileges for the data source and destination objects
  3. Establishes the optimum path for accessing data within the enterprise

As shown in the following figure, the Teradata PT processor calls the five operator entry points of each operator defined in the job script in a coordinated manner that optimizes job data flow. These entry points (Initiate, Execute, Checkpoint, Restart, and Terminate) are implemented as functions of the Teradata PT operator interface.

The Teradata PT processor can launch multiple instances of any operator defined for parallel execution to scale up performance through parallel processing.
Parallel Plan Implementation