Can a Star Schema Contain Outriggers?

user_17179235 0
Viewed 63

My understanding from Star Schema modelling is that dimensions must directly link to a fact table. If this is true, then a star schema can't contain Outrigger dimension table. So, is this statement true that if a schema contains Outrigger dimension, it is snowflake?

Thank you

snowflake-schema star-schema data-warehouse data-modeling
1 Answers

Neither of the terms “star schema” or “snowflake” have precise definitions that are generally accepted. If you want to describe your model as a star schema, a star schema with outriggers or a snowflake then that is entirely up to you.

user_136583990
Related