Differences between star and snowflake schemas?

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

(Continued from previous question...)

Differences between star and snowflake schemas?

Star schema
A single fact table with N number of Dimension

Snowflake schema
Any dimensions with extended dimensions are know as snowflake schema

(Continued on next question...)

Other Job Interview Questions

• What is Normalization, First Normal Form, Second Normal Form , Third Normal Form?
• What are modeling tools available in the Market?
• What are the possible data marts in Retail sales.?
• What are conformed dimensions?
• Why are OLTP database designs not generally a good idea for a Data Warehouse?
• How do you load the time dimension?
• Why fact table is in normal form?
• What are non-additive facts?
• What is Dimensional Modelling? Why is it important ?
• What is the main difference between Inmon and Kimball philosophies of data warehousing?
• More...