What is Dimensional Modelling? Why is it importa

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

(Continued from previous question...)

What is Dimensional Modelling? Why is it important ?

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measuremnets ie, the dimensions on which the facts are calculated.

(Continued on next question...)

Other Job Interview Questions

• Differences between star and snowflake schemas?
• What are the various Reporting tools in the Market?
• What are the different architecture of datawarehouse?
• What is a CUBE in datawarehousing concept?
• Why fact table is in normal form?
• What is Dimensional Modelling? Why is it important ?
• What is the difference between ODS and OLTP?
• What is hybrid slowly changing dimension?
• What Snow Flake Schema?
• Why Denormalization is promoted in Universe Designing?
• More...