What Is Star Schema And Snowflake Schema?

1.	What Is Star Schema And Snowflake Schema?
Answer» Star SCHEMA is a HIGHLY denormalized schema whereas SNOWFLAKE schema is hight NORMALIZED schema.Star schema is CHARACTERIZED by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables. Star Schema is a highly denormalized schema whereas snowflake schema is hight normalized schema.Star schema is characterized by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables.

Answer»

Star SCHEMA is a HIGHLY denormalized schema whereas SNOWFLAKE schema is hight NORMALIZED schema.Star schema is CHARACTERIZED by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables.

Star Schema is a highly denormalized schema whereas snowflake schema is hight normalized schema.Star schema is characterized by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables.

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?