Explain Fast Load in Teradata?
Loads large amount of data from external file into
an empty table at high speed.Only load one empty table with 1 fast load
job.Tables defined with Referential integrity, secondary indexes, join indexes,
hash indexes or triggers cannot be loaded with FastLoad.Duplicate rows cannot
be loaded into a multiset table with FastLoad
FastLoad has two phases – Data Acquisition and
Application. It requires separate error table for each phase. Use the BEGIN
LOADING statement to specify (and create) the two error tables for the
operation.
We can specify the error table in the same database
as the data table or different database.
We must remove the error tables before we re-run
the same load job or it will terminate in an error condition.
No comments:
Post a Comment