Fact Constellation Schema
- In fact Constellation there are multiple fact tables. This schema is also known as galaxy schema.
- In the following diagram we have two fact tables namely, sales and shipping.
The sale fact table is same as that in star schema.
- The shipping fact table has the five dimensions namely, item_key, time_key, shipper-key, from-location.
- The shipping fact table also contains two measures namely, dollars sold and units sold.
- It is also possible for dimension table to share between fact tables. For example time, item and location dimension tables are shared between sales and shipping fact table.
No comments:
Post a Comment