Job Example 13: Extracting Rows and Sending Them in Indicator-mode Format - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.00
Published
August 31, 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
zae1544831938751.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Objective

Extract rows from database tables using Export operator and write them to an external target as indicator-mode data.

Data Flow Diagram

The following figure shows a diagram of the job elements for Job Example 13.

Job Example PTS00018 – Extracting Rows and Sending Them in Binary or Indicator-mode Format

Sample Script

For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:

PTS00018: Exporting Rows and Writing Them as Binary or Indicator Mode Data

Rationale

This job uses the operators shown for the following reasons:
  • Use Export operator because it can extract large amounts of data from a database table at high speeds.
  • DataConnector operator because it can write data to an external flat file.