15.00 - How it Works - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2409-034K

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.