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