Run Multifile Teradata FastLoad Jobs - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Run Multifile Teradata FastLoad Jobs

This section covers the things to consider when running a multifile Teradata FastLoad job.

A multifile Teradata FastLoad job is one that loads the Teradata FastLoad table with input data from more than one source. Do this by:

1 Using a LOGOFF command, with no END LOADING command, to intentionally pause the Teradata FastLoad job after the job has been initiated and loaded the data from the first source.

2 Successively restarting and pausing the Teradata FastLoad job to load the data from each subsequent input source.

3 Using an END LOADING command to terminate the Teradata FastLoad job after the data from the last input source has been loaded.

Note: When running a multifile Teradata FastLoad job, the Teradata FastLoad table and the two error tables remain locked and are not available to users until the END LOADING command is used to conclude the Teradata FastLoad job.

The following subsections provide example Teradata FastLoad job scripts that show how to load a table called Fast_Table with data stored in three different input data sources (FirstFile, SecondFile, and ThirdFile). “Command Functions” on page 73 describes each of the commands in the three job scripts.

For a complete example using all loading commands, see Appendix C: “INMOD and Notify Exit Routine Examples.”