About FastLoad - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update
Product Category
Teradata Vantage

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