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

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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