Why Denormalization is promoted in Universe Desi

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

(Continued from previous question...)

Why Denormalization is promoted in Universe Designing?

In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called DIMENSION table for performance and slicing data.Due to this merging of tables into one large Dimension table, it comes out of complex intermediate joins. Dimension tables are directly joined to Fact tables.Though, redundancy of data occurs in DIMENSION table, size of DIMENSION table is 15% only when compared to FACT table. So only Denormalization is promoted in Universe Desinging.

(Continued on next question...)

Other Job Interview Questions

• explain in detail about type 1, type 2(SCD), type 3 ?
• What are the vaious ETL tools in the Market?
• What are the Different methods of loading Dimension tables?
• What is Fact table?
• Why should you put your data warehouse on a different system than your OLTP system?
• What are Aggregate tables?
• What is ETL?
• What is data mining?
• What is Normalization, First Normal Form, Second Normal Form , Third Normal Form?
• Is OLAP databases are called decision support system ??? true/false?
• More...