Job Example 12: Extracting Rows and Sending Them in Delimited Format - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Example 12: Extracting Rows and Sending Them in Delimited Format

Job Objective

Extract rows from Teradata Database tables and write them to an external target file as delimited data.

Data Flow Diagram

Figure 37 shows a diagram of the job elements for Job Example 10.

Figure 37: Job Example PTS00016, PTS00017 -- Extracting Rows and Sending Them in Delimited Format

Sample Script

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

PTS00016: Extracting Rows and Writing Them in Delimited Format using the Export operator.

PTS00017: Extracting Rows and Writing Them in Delimited Format using the SQL Selector operator.

Rationale

This job uses the:

  • Export operator for exporting data from a Teradata Database table with the schema that matches the table.
  • SQL Selector operator for extracting data from a Teradata Database table in field mode (character format).
  • DataConnector operator because it is the only operator that can write character data to an external flat file in delimited format.