What are the Different methods of loading Dimens

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the Different methods of loading Dimension tables?

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.

(Continued on next question...)

Other Job Interview Questions

• What are non-additive facts?
• What is data validation strategies for data mart validation after loading process ?
• What is surrogate key ? where we use it expalin with examples
• what is junk dimension? what is the difference between junk dimension and degenerated dimension?
• What are the possible data marts in Retail sales.?
• What Snow Flake Schema?
• What is Normalization, First Normal Form, Second Normal Form , Third Normal Form?
• What is a Star Schema?
• What are the advantages data mining over traditional approaches?
• What is BUS Schema?
• More...