Any dimensions with extended dimensions are know as snowflake schema
star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?