MultiLoad Utility | Teradata Vantage - MultiLoad Utility - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

MultiLoad allows you to upload data from the client to your Vantage system. It operates on multiple tables simultaneously and can also insert, update, and delete data.

The maximum number of MultiLoad jobs you can run is 30. The default is 5. You can also change the maximum number of jobs allowed by defining throttle rules through the Teradata Viewpoint Workload Designer portlet. (See Maximum Number of Concurrent FastLoad, MultiLoad, and FastExport Jobs for more information.)

To improve performance:
  • Minimize concatenation and redefinition of input data.
  • Restrict the number of NUSIs.
  • Make the PI of each data table unique or nearly unique.
  • Minimize the use of error tables.
  • Do not checkpoint too often.
  • Avoid using too many sessions.
MultiLoad does not support the following:
  • Aggregate operators
  • Exponential operators
  • Arithmetic functions
  • Concatenation of data files
  • Hexadecimal forms
  • NoPI tables
  • Foreign keys
  • Loading LOBs
  • Column-partitioned tables

For more information, see Teradata® MultiLoad Reference, B035-2409

You can perform the following steps as an alternative to using MultiLoad:

  1. Create a staging table that is otherwise identical with the target table, but has no constraints, triggers, or indexes defined on it, such as a NoPI.
  2. Import into the staging table from the external source (for example, using FastLoad or Teradata Parallel Data Pump Array INSERT operations).
  3. (Optional) create an error table for the target table if error logging is desired.
  4. Execute a MERGE into the target table using the staging table as source.
  5. Drop the staging table and error table.

For information on NoPI tables or Teradata Parallel Data Pump Array INSERT operations, see Teradata Vantage™ - Database Design, B035-1094.

Related Information

For more information on... See...
MERGE
  • the Orange Book "Exploring the Benefits of Teradata 12.0 – ANSI MERGE Enhancements.”
  • Teradata Vantage™ - SQL Data Manipulation Language, B035-1146
MERGE INTO Teradata Vantage™ - SQL Data Manipulation Language, B035-1146