General Datawarehousing Interview Question:

Explain What are the Different methods of loading Dimension tables?

Submitted by: Administrator

Conventional Load:
Before loading the data, all the Table constraints will be checked against the data.

Direct load:(Faster Loading)
All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed.
Submitted by: Administrator