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.


  1. Hi Babu,

    A fact constellation schema means two or more fact tables sharing one or more dimensions? I mean if a star schema dimension model has one or more conformed dimension then its said to be in fact constellation schema?