FastLoad | Teradata Vantage - FastLoad 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™

FastLoad allows you to load data from the client to your Vantage system. It allows fast loading of a single empty table that has no SIs, JIs, HIs, RI (FKs), or column partitioning.

FastLoad loads large amounts of data into an empty table, with or without a primary index, on Analytics Database. However, row size and the number of columns, more than any other factors, do affect performance.

When you load large tables, consider the following things.

IF you are loading a large table… THEN…
with fallback
  • Observe the suggestions for loading the large table without fallback.
  • Create the table without fallback protection.
  • Load the table.
  • Use BTEQ to alter the table to have fallback protection.
without fallback
  • Initially, set session to the number of AMPs in your system. Then, experiment by reducing the number of sessions.
  • Avoid checkpointing too frequently.
  • Avoid NULLIF clauses, VAR fields, or indicator bits whenever possible.
  • Run concurrent FastLoad jobs. The maximum number of FastLoad jobs you can run is 30. The default is 5. (See Teradata Vantage™ - Database Utilities, B035-1102 for more information.) You can also change the maximum number of jobs allowed by defining throttle rules through the Teradata Viewpoint Workload Designer portlet. For more information on FastLoad, see Maximum Number of Concurrent FastLoad, MultiLoad, and FastExport Jobs.
You cannot use the NO FALLBACK option and the NO FALLBACK default on platforms optimized for fallback.
FastLoad does not support the following:
  • HIs
  • JIs
  • FKs
  • SIs (Both USIs and NUSIs are not supported)
  • LOBs
  • Column partitioning

For more information on this utility, see Teradata® FastLoad Reference, B035-2411