Job Example 19: Export Data from a Table and Load It into an Empty Table
Job Objective
Export data from Teradata Database staging tables before loading it into an empty production table in either the same or a different Teradata Database.
Data Flow Diagram
Figure 45 shows a diagram of the job elements for Job Example 15.
Figure 45: Job Example PTS00022 -- Exporting Data and Loading It into Production TablesSample Script
For the sample script that corresponds to this job, see the following script in the sample/userguide directory:
PTS00022: Extracting Data from a Teradata Database Staging Table and Loading It into a Production Table.
Rationale
This job uses:
Note: The SQL operator extracts data more slowly than the Export operator. However, the SQL Selector operator can be used if the Teradata Database is short on load slots, because the SQL Selector operator does not use Teradata Database load slots.