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.
there are some other ways of recovery excel 2007 files
ReplyDeleteHi Babu,
ReplyDeleteA 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?
Thanks,
Reginold.