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

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

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

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