STAR Schema SNOWFLAKE Shema
In Data Warehousing star schema is one of the simplest schemas. A Snowflake schema is a complex one as it contains more dimensions.
The structure looks like a star which consists of fact tables and associated dimension tables. Data is structured in the snowflake form and split into more tables after normalization.
It has simple database designs It has complex database designs and data handling storage.
Fast cube processing is done in a star schema. Slower cube processing is done in a snowflake schema.
It has high chances of data redundancy. It has low chances of data redundancy.
In this schema, the dimensions hierarchy is stored in the form of dimensions tables. In this schema, hierarchy is stored in the form of an individual table.
BY Best Interview Question ON 14 Nov 2022