Job Objective
Extract rows from 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.
Job Example PTS00018 – Extracting Rows and Sending Them in Binary or Indicator-mode Format
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 database table at high speeds.
- DataConnector operator because it can write data to an external flat file.