Job Example 3: Loading BLOB, CLOB, and JSON Data - Parallel Transporter

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 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 Teradata Database tables.