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

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

Job Objective

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

Data Flow Diagram

Figure 48 shows a diagram of the job elements for Job Example 18.

Figure 48: ob Example PTS00025, PTS00028-- Export BLOB/CLOB Data from One Teradata Database Table to Another

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.