Fact Constellation: Fact Constellation allows you to connect multiple facts to dimensions. It is combination of multiple stars connected with each other using dimension, hence called Galaxy or Fact Constellation schema.
As compared to Star and snowflake it is used for more sophisticated application. The dimension tables could be normalized or not as per the requirement.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how is galaxy or fact constellation schema would look like.
Characteristics of Fact Constellation schema:
As compared to Star and snowflake it is used for more sophisticated application. The dimension tables could be normalized or not as per the requirement.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how is galaxy or fact constellation schema would look like.
Characteristics of Fact Constellation schema:
- Complex design
- Different variants of aggregations
- Suitable for more sophisticate application
No comments:
Post a Comment