This section covers the things to consider when running a multifile Teradata FastLoad job.
- 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.
- Successively restarting and pausing the Teradata FastLoad job to load the data from each subsequent input source.
- Using an END LOADING command to terminate the Teradata FastLoad job after the data from the last input source has been loaded.
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 describes each of the commands in the three job scripts.
For a complete example using all loading commands, see INMOD and Notify Exit Routine Examples.