Job Example 3: Loading BLOB, CLOB, and JSON Data
Job Objective
Load BLOB/CLOB/JSON data from files in the deferred mode into a Teradata table.
For detailed information on deferred LOB/JSON processing, see Teradata Parallel Transporter Reference.
Data Flow Diagram
Figure 25 shows a diagram of the job elements for Job Example 3.
Figure 25: Job Example PTS00006, PTS00026-- Loading BLOB/CLOB/JSON DataSample Script
For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:
PTS00006: Loading BLOB and BLOB Data into Teradata Database.
PTS00026: Loading JSON Data into Teradata Database.
Rationale
This job uses: