What Is The Main Difference Between Star And Snowflake Star Schema? W

1.	What Is The Main Difference Between Star And Snowflake Star Schema? Which One Is Better And Why?
Answer» 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. 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.

What Is The Main Difference Between Star And Snowflake Star Schema? Which One Is Better And Why?

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?