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…|
FastLoad does not support the following:
- SIs (Both USIs and NUSIs are not supported)
- Column partitioning
For more information on this utility, see Teradata FastLoad Reference.