Job Example 22: Export BLOB/CLOB/JSON Data from One Teradata Table to Another - Parallel Transporter

Job Objective

Move rows of data containing BLOB/CLOB/JSON data between two Teradata Database tables.

Data Flow Diagram

The following figure shows a diagram of the job elements for Job Example 22.

Sample Script

For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:

• PTS00025: Exporting BLOB/CLOB Data from One Teradata Database Table and Loading It into Another.
• PTS00028: Exporting JSON Data from One Teradata Database Table and Loading It into Another.

Rationale

This job uses the operators shown for the following reasons:

• Use the SQL Selector and SQL Inserter operators because they are the only operators that can export and load rows containing BLOB/CLOB/JSON data.