What is the difference between star schema and snowflake schme

Question

Accepted Answer

Star schema has a single fact table connected to multiple dimension tables directly, while snowflake schema has normalized dimension tables connected to each other.

Star schema has denormalized dimension tables, making it easier to query but potentially less efficient for storage.
Snowflake schema has normalized dimension tables, reducing redundancy but potentially making queries more complex.
Star schema is more suitable for data warehousing applications with simpler queries, while snowflake schema is better for complex data models with many-to-many relationships.
Example: A star schema for a sales database would have a fact table for sales transactions connected directly to dimension tables for products, customers, and time. A snowflake schema for the same database might have separate dimension tables for product categories, subcategories, and products.

What is the difference between star schema and snowflake schme

Top TCS ETL Tester interview questions & answers

Popular interview questions of ETL Tester