Answers

Question and Answer:

  Home  Data Warehousing

⟩ What is the main difference between star and snowflake star schema? Which one is better and why?

If u have one to may relation ship in the data then only we choose snowflake schema, as per the performance-wise every-one go for the Star schema. Moreover, if the ETL is concerned with reporting means choose for snowflake because this schema provides more browsing capability than the former schema.

 173 views

More Questions for you: