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 FormatSample 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: