MultiLoad
From Wikipedia, the free encyclopedia
 |
This article or section is written like an advertisement. Please help rewrite this article from a neutral point of view per Wikipedia policy. Mark blatant advertising for speedy deletion with {{db-spam}}. (help, talk) |
MultiLoad is a Teradata utility.
Contents |
[edit] Teradata MultiLoad – Data Maintenance
A time-tested, highly reliable, parallel load utility, Teradata MultiLoad is used to create and maintain Teradata Databases. MultiLoad optimizes operations that rapidly acquire, process, and apply data to tables in a Teradata Database. For data maintenance, MultiLoad updates, inserts, upserts, and deletes large volumes of data into empty or populated tables. MultiLoad works at the data block level, providing a faster alternative to insert/select operations that touch a significant portion of the target table. A single MultiLoad job can maintain up to five Teradata tables by extracting large volumes of data, locking the destination tables, then loading data rapidly using block level updates. Like FastLoad, MultiLoad runs on a variety of client platforms, operates in a fail-safe mode, and is fully recoverable.
[edit] Features
- High-performance maintenance operations applies updates to multiple tables in single pass
- Best for over 1-2% of rows changed
[edit] Supported Platforms
- NCR UNIX SVR4 MP-RAS
- IBM z/OS (MVS and USS)
- z/OS VM
- Microsoft Windows 2000, XP, and Server 2003
- Sun Solaris SPARC
- IBM
- HP-UX
[edit] Description
The Teradata 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 Relational Database Management System (RDBMS).
Using a single MultiLoad job, you can do a number of different import and delete tasks on RDBMS 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 RDBMS receiving the data can be any existing table or view for which you have access privileges for the maintenance tasks you want to do.
