FastLoad | VantageCloud Lake - FastLoad Utility - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Use FastLoad to load data from the client to your Vantage system. FastLoad 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.

Option What You Must Do
With fallback
  • See 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 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:
  • HI
  • JI
  • FK
  • USI
  • NUSI
  • LOB
  • Column partitioning

See Teradata® FastLoad Reference, B035-2411.