Search this blog

Showing posts with label Fact Constellation schema. Business Intelligence. Show all posts
Showing posts with label Fact Constellation schema. Business Intelligence. Show all posts

Saturday, June 19, 2010

BI: Dimensional Model - Fact Constellation schema architecture

Fact Constellation schema: 
As its name implies, it is shaped like a constellation of stars (i.e., star schemas). This schema is more complex than star or snowflake varieties, which is due to the fact that it contains multiple fact tables. This allows dimension tables to be shared amongst the fact tables. A schema of this type should only be used for applications that need a high level of sophistication.