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

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Job Objective

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

Data Flow Diagram

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

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).