Defining Standalone Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities
A standalone operator can be used for processing that does not involve sending data to or receiving data from the Teradata PT operator interface, and thus does not use data streams. If a standalone operator is used, it must be:
  • The only operator used in the script, if job steps are not used
  • The only operator used in the job step, if job steps are used

The following table contains a list of Teradata PT standalone operators.

Operator Definition
DDL Executes SQL statements before or after the main extract and load job steps, for job setup or cleanup. For example, you can create tables and create indexes before starting a job, or drop work tables, as needed, after a job.
Update (standalone) Use the Update operator as a standalone operator only in cases where it is performing the Delete Task and there is no data needed for the DELETE SQL request.
OS Command Executes OS commands on the client host system as part of the Teradata PT job execution.