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 Advanced SQL Engine. 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 |
|
| without fallback |
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