Star Schema vs Snowflake Schema

Star schema is preferred

Why:
Why because star schema is simple queries and logic, but snowflake schema is good for complex queries and logic.
If the table space is not enough to maintain a STAR schema then we should go for snowflake instead of STAR Schema.
I.e. The table should be spited in to multiple tables.

Eg: If you want to maintain time data in one table like year, month, day in one table in star schema, you need to spit this data into 3 tables like year, month, and day in snowflake schema.

Leave a Reply

Your email address will not be published. Required fields are marked *