Job Example 16: Export Data and then Use It to Perform Conditional Updates Against Production Tables
Job Objective
Export data from Teradata Database tables and perform conditional updates using CASE logic against existing production tables in the same or in another Teradata Database.
Data Flow Diagram
Figure 46 shows a diagram of the job elements for Job Example 16.
Figure 46: Job Example PTS00023 -- Export Data and Perform Conditional Updates Against Production TablesSample 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: