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 - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.

(Continued on next question...)

Other Job Interview Questions

• What are modeling tools available in the Market?
• What is VLDB?
• What is the difference between datawarehouse and BI?
• What are conformed dimensions?
• What's A Data warehouse
• What are modeling tools available in the Market?
• What is snapshot?
• Why Denormalization is promoted in Universe Designing?
• What are the advantages data mining over traditional approaches?
• What is surrogate key ? where we use it expalin with examples
• More...