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 Teradata Database
- Submits special Teradata SQL requests to Teradata Database
- Creates and protects temporary work tables and error tables in Teradata Database
|
DML Transaction |
Submits the DML statements specifying the insert, update, and delete tasks to Teradata Database |
Acquisition |
- Imports data from the specified input data source
- Evaluates each record according to specified application conditions
- Loads the selected records into the worktables in Teradata Database
(There is no acquisition phase activity for a Teradata MultiLoad delete task.)
|
Application |
- Acquires locks on the specified target tables and views in Teradata Database
- For an import task, inserts the data from the temporary work tables into the target tables or views in Teradata Database
- For a delete task, deletes the specified rows from the target table in Teradata 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 Teradata Database
- Reports the transaction statistics associated with the import and delete tasks
|