About this document
Star vs. Snowflake Schema Explained by msrinath89 is a document available to read on EtoBox.
Star schema and snowflake schema are two common data warehouse schemas. Star schema has one fact table connected to multiple dimension tables, while snowflake schema further normalizes the dimension tables. Star schema is simpler but less normalized, while snowflake schema is more normalized but can impact query performance. Both schemas are generally used in data warehousing, with star schema preferred for simpler structures with less data.
- Author
- msrinath89
- Language
- EN