difference between star schema and snowflake schema

Question

Accepted Answer

Star schema has a single centralized fact table with denormalized dimensions, while snowflake schema has normalized dimensions in separate tables.

Star schema is simpler and easier to understand, while snowflake schema allows for more flexibility and normalization.
In star schema, dimensions are denormalized and directly connected to the fact table, while in snowflake schema, dimensions are normalized and split into multiple related tables.
Star schema is more suitable for simpler queries and reporting, while snowflake schema is better for complex queries and analysis.
Example: A star schema for a sales database would have a fact table for sales transactions connected to dimension tables for products, customers, and time. A snowflake schema for the same database would have separate tables for product categories, subcategories, and products.

Popular interview questions of Analyst