How we are going to decide which schema we are going to implement in the data warehouse?

Ie. whether it should be Star schema or snow flake schema?
  • Interview Candidate
  • 3
  • 3527

Showing Answers 1 - 3 of 3 Answers

SashaFroyland

  • Mar 1st, 2008
 

Pro Star Schema:



  • Users find easier to query and faster query times.

  • Space consequences of repeated data makes little difference as Dimensional
    table hold relatively fewer rows then the large Fact tables.


Pro Snowflake Schema:



  • DBA find easier to maintain

  • May exist in stage but should be de-normalized in Production.

  • Cleanest designs use surrogate keys for all dimension levels.

  • Smaller storage size because normalized data takes less space.


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions