Job Example 7: Mini-Batch Loading
Job Objective:
Read data directly from one or more external flat files and write it to a Teradata Database table.
Note: This job represents a special case of high speed loading, where the destination table is already populated, or has join indexes or other restrictions that prevent it from being accessed by the Load operator. Because of this, the job includes an intermediate step that loads the data into a staging table and then uses the DDL operator with INSERT…SELECT to move the data into the final destination table.
Data Flow Diagrams
Figure 31 shows a flow diagram of the elements of Job Example 7.
Figure 31: Job Example PTS00013 -- Mini-Batch LoadingSample Script
For the sample script that corresponds to this job, see the see the following script in the sample/userguide directory:
PTS00013: Mini-Batch Loading into Teradata Database Tables.
Rationale
This job uses: