Job Example 16: Extract BLOB/CLOB/JSON Data and Write It to an External File
Job Objective
Extract rows that include BLOB/CLOB/JSON data from a Teradata Database table and write them to an external flat file.
Data Flow Diagram
Figure 41 shows a diagram of the elements for Job Example 14.
Figure 41: Job Example PTS00021, PS00027-- Extract BLOB/CLOB/JSON Data and Write It to an External FileSample Script
For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:
PTS00021: Extracting BLOB/CLOB Data and Writing It to an External Target.
PTS00027: Extracting BLOB/CLOB/JSON Data and Writing It to an External Target.
Rationale
This job uses the operators shown for the following reasons: