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

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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

Job Objective

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

Data Flow Diagram

Figure 38 shows a diagram of the job elements for Job Example 11.

Figure 38: 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, ee 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 Teradata Database table at high speeds.
  • DataConnector operator because it can write data to an external flat file.