Star vs snowflake schema

Question

Accepted Answer

Star schema is a denormalized schema with a single central fact table surrounded by dimension tables. Snowflake schema is a normalized schema with multiple interconnected dimension tables.

Star schema is easier to understand and query due to denormalization.
Snowflake schema saves storage space by normalizing data.
Star schema is better for data warehousing and reporting, while snowflake schema is better for OLAP systems.
Example: A star schema for a sales database would have a fact table for sales transactions surrounded by dimension tables for products, customers, and time.
Example: A snowflake schema for the same sales database would have separate dimension tables for product categories, product subcategories, and products.

Star vs snowflake schema

Top Tiger Analytics Senior Modeller interview questions & answers

Popular interview questions of Senior Modeller