What it Does - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

When Teradata MultiLoad is invoked, the utility executes the Teradata MultiLoad commands and Teradata SQL statements in the Teradata MultiLoad job script.

The following table describes the phases of Teradata MultiLoad operations.

Phases of Teradata MultiLoad Operation
Phase Teradata MultiLoad Operation
Preliminary
  1. Parses and validates all of the Teradata MultiLoad commands and Teradata SQL statements in a Teradata MultiLoad job
  2. Establishes sessions and process control with Teradata Database
  3. Submits special Teradata SQL requests to Teradata Database
  4. 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
  1. Imports data from the specified input data source
  2. Evaluates each record according to specified application conditions
  3. Loads the selected records into the worktables in Teradata Database

(There is no acquisition phase activity for a Teradata MultiLoad delete task.)

Application
  1. Acquires locks on the specified target tables and views in Teradata Database
  2. For an import task, inserts the data from the temporary work tables into the target tables or views in Teradata Database
  3. For a delete task, deletes the specified rows from the target table in Teradata Database
  4. Updates the error tables associated with each Teradata MultiLoad task
Cleanup
  1. Forces an automatic restart/rebuild if an AMP went offline and came back online during the application phase
  2. Releases all locks on the target tables and views
  3. Drops the temporary work tables and all empty error tables from Teradata Database
  4. Reports the transaction statistics associated with the import and delete tasks