Description - 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

The Teradata MultiLoad utility is an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a database.

A single Teradata MultiLoad job performs a number of different import and delete tasks on database tables and views:
  • Each Teradata MultiLoad import task can do multiple data insert, update, and delete functions on up to five different tables or views.
  • Each Teradata MultiLoad delete task can remove large numbers of rows from a single table.
Use Teradata MultiLoad to import data from:
  • Disk or tape files (using a custom Access Module) on a mainframe-attached client system
  • Input files on a workstation-attached workstation
  • Special input module (INMOD) programs written 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 privileges for maintenance tasks have been granted.

Full tape support is not available for any function in Teradata MultiLoad for workstation-attached client systems. To import data from a tape, a custom access module that interfaces with the tape device must be written. For information about how to write a custom access module, see the Teradata® Tools and Utilities Access Module Programmer Guide, B035-2424.