Job Example 1: High Speed Bulk Loading into an Empty Table
Job Objective
Read large amounts of data directly from an external flat file, or from an access module, and write it to an empty Teradata Database table. If the source data is an external flat file, this job is equivalent to using the Teradata FastLoad utility. If the data source is a named pipe, the job is equivalent to using the Teradata standalone DataConnector utility to access data from a named pipe, through an access module, and write it to a temporary flat file, and then running a separate FastLoad job to load the data from the temporary file.
Note: In cases where data is read from more than one source file, use UNION ALL to combine the data before loading into a Teradata Database table, as shown in Job Example 1C.
Data Flow Diagrams
Figure 20 through Figure 22 show flow diagrams of the elements in each of the three variations of Job Example 1.
Figure 20: Job Example PTS00001 -- Reading Data from a Flat File for High Speed LoadingSamples Scripts
For the sample scripts that correspond to the three variations of this job, see the following scripts in the sample/userguide directory:
Rationale
This job uses: