Job Objective
Load BLOB/CLOB/JSON data from files in the deferred mode into a database table.
For more information on deferred LOB/JSON processing, see Teradata® Parallel Transporter Reference, B035-2436.
Data Flow Diagram
The following figure shows a diagram of the job elements for Job Example 3.
Job Example PTS00006, PTS00026 – Loading LOB/CLOB/JSON Data
Sample 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:
- OS Command operator because it is the only operator that can copy a flat file from one directory to another on the client system.
- DDL operator because it can DROP work tables and CREATE target tables prior to loading
- DataConnector operator because it is the only producer operator that reads inline LOB data from external flat files.
- SQL Inserter operator as the consumer operator because it the only operator that can load BLOB/CLOB/JSON data into database tables.