Job Example 20: Export Data and then Use It to Perform Conditional Updates Against Production Tables - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.00
Published
August 31, 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
zae1544831938751.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Objective

Export data from database tables and perform conditional updates using CASE logic against existing production tables in the same or in another database.

Data Flow Diagram

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

Job Example PTS00023 – Export Data and Perform Conditional Updates Against Production Tables

Sample Script

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

PTS00023: Exporting Data and then Use It to Performing Conditional Updates Against Production Tables

Rationale

This job uses the operators shown for the following reasons:
  • Use Export operator because it can extract large amounts of data from a database table at high speeds.
  • Use Update operator as the consumer operator because it can perform INSERT, UPDATE, and DELETE operations in database tables.