Data warehousing star & snowflake

Data warehousing - Difference between star and snowflake schemas - August 07, 2008 at 17:10 pm by Rajmeet Ghai

Explain the difference between star and snowflake schemas.

A snow flake schema design is usually more complex than a start schema. In a start schema a fact table is surrounded by multiple fact tables. This is also how the Snow flake schema is designed. However, in a snow flake schema, the dimension tables can be further broken down to sub dimensions. Hence, data in a snow flake schema is more stable and standard as compared to a Start schema.

E.g. Star Schema: Performance report is a fact table. Its dimension tables include performance_report_employee, performance_report_manager

Snow Flake Schema: the dimension tables can be broken to performance_report_employee_weekly, monthly etc.

Data warehousing - Difference between star and snowflake schemas - May 11, 2009 at 14:40 pm by Vidya Sagar

Explain the difference between star and snowflake schemas.

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.


  • A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.
  • The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.
Data warehousing - Differences between star and snowflake schema.  - May 19, 2009 at 11:40 am by Rajmeet Ghai

Differences between star and snowflake schema.

A snowflake schema is a more normalized form of a star schema. In a star schema, one fact table is stored with a number of dimension tables. On the other hand, in a star schema, one dimension table can have multiple sub dimensions. This means that in a star schema, the dimension table is independent without any sub dimensions.


Write your comment - Share Knowledge and Experience

More Related Links
What is Data warehousing?

Answer - A data warehouse can be considered as a storage area where interest specific or relevant data........            

What are fact tables and dimension tables?

Answer - As mentioned, data in a warehouse comes from the transactions. Fact table in a data warehouse consists........

What is ETL process in data warehousing?

Answer - ETL is Extract Transform Load. It is a process of fetching.........

Explain the difference between data mining and data warehousing.

Answer - Data warehousing is merely extracting data from different sources, cleaning the........

Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us