19. MultiLoad Utility

MultiLoad Utility

The MultiLoad utility gives you an efficient way to deal with batch

maintenance of large databases. MultiLoad is a command -driven utility

you can use to do fast, high-volume maintenance on multiple tables and

views of a Teradata Database. Using a single MultiLoad job, you can do a

number of different import and delete tasks on database tables and views:

·

Each MultiLoad import task can do multiple data insert, update, and

delete functions on up to five different tables or views.

·

Each MultiLoad delete task can remove large numbers of rows from a

single table. You can use MultiLoad to import data from:

·

Disk or tape files on a channel-attached client system

·

Input files on a network-attached workstation

·

Special input module (INMOD) programs you write to select,

validate, and preprocess input data

·

Access modules

·

Any device providing properly formatted source data

The table or view in the database receiving the data can be any existing

table or view for which you have access privileges for the maintenance

tasks you want to do.

How it Works ?

MultiLoad processes a series of MultiLoad commands and Teradata SQL

statements you enter usually as a batch mode job script. You use the

MultiLoad commands for session control and data handling of the data

transfers. The Teradata SQL statements do the actual maintenance

functions on the database tables and views.