| Preliminary |
- Parses and validates all of the Teradata MultiLoad commands and Teradata SQL statements in a Teradata MultiLoad job
- Establishes sessions and process control with the database
- Submits special Teradata SQL requests to the database
- Creates and protects temporary work tables and error tables in the database
|
| DML Transaction |
Submits the DML statements specifying the insert, update, and delete tasks to the database |
| Acquisition |
- Imports data from the specified input data source
- Evaluates each record according to specified application conditions
- Loads the selected records into the work tables in the database
(There is no acquisition phase activity for a Teradata MultiLoad delete task.)
|
| Application |
- Acquires locks on the specified target tables and views in the database
- For an import task, inserts the data from the temporary work tables into the target tables or views in the database
- For a delete task, deletes the specified rows from the target table in the database
- Updates the error tables associated with each Teradata MultiLoad task
|
| Cleanup |
- Forces an automatic restart/rebuild if an AMP went offline and came back online during the application phase
- Releases all locks on the target tables and views
- Drops the temporary work tables and all empty error tables from the database
- Reports the transaction statistics associated with the import and delete tasks
|