Starschema and snowflake schema

When should a star schema be used and when a snowflake schema should be used, explain in brief?

E

Expert

Verified

A star schema refers to a simplest data warehouse schema. Snowflake schema is same as that of the star schema. It generally normalizes the dimension table in order to save the data storage space. It may be used in order to represent the hierarchies of the information.

   Related Questions in Biology

©TutorsGlobe All rights reserved 2022-2023.