Why is the snowflake schema normalized, even though the data warehouse has the property of being denormalized? I am learning about data warehouse technologies, can anyone elaborate on this for me? I apologize if I am missing something here, I am open to suggestions. :)
Thanks!
Data warehouses may be denormalised but that’s not mandatory, only some kinds of data warehouse modelling use denormalisation as part of its design principles.
For a dimension, a snowflake model describes when a dimension is modelled using normalisation. It could still be part of a data warehouse though.
The kimball approach advises to avoid snowflakes in a data warehouse because it prefers denormalised dimensions.