What it Does - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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.

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 the database
  3. Submits special Teradata SQL requests to the database
  4. 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
  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 work tables in the 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 the database
  2. For an import task, inserts the data from the temporary work tables into the target tables or views in the database
  3. For a delete task, deletes the specified rows from the target table in the 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 the database
  4. Reports the transaction statistics associated with the import and delete tasks