About FastLoad - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

FastLoad allows you to load data from the client to your Teradata Database 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 Teradata 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…


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 Utilities 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 FastLoads, see “Maximum Number of Concurrent FastLoad, MultiLoad, and FastExport Jobs” on page 141.
  • 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.