Job Objective
Export data from database staging tables before loading it into an empty production table in either the same or a different database.
Data Flow Diagram
The following figure shows a diagram of the job elements for Job Example 19.
Job Example PTS00022 – Exporting Data and Loading It into Production Tables
Sample 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:
- DDL operator because it can DROP work tables and CREATE new target tables prior to loading.
- Export operator because it can extract large amounts of data from a database table at high speed.The SQL operator extracts data more slowly than the Export operator. However, the SQL Selector operator can be used if the database is short on load slots, because the SQL Selector operator does not use database load slots.
- Load operator because it can load large amounts of data into an empty database table at high speed.