How it Works - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

How it Works

Teradata MultiLoad processes a series of commands and Teradata SQL statements which are usually entered as a batch mode job script. The Teradata MultiLoad commands perform session control and data handling of the data transfers. The Teradata SQL statements do the actual maintenance functions on the database tables and views.

Serialization of Changes

In certain uses of Teradata MultiLoad, it is possible to have multiple changes to one row in the same job. For example, the row may be inserted and then updated during the batch job, or it may be updated and then deleted. In any case, the correct ordering of these operations is obviously very important. Teradata MultiLoad automatically guarantees that this ordering of operations is maintained correctly.