If you draw a diagram of your dimensional tables, how a fact table is related (surrounded) to its dimension tables, you'll see a star schema. The fact table is the star's centre; the dimension tables, the corners.
Your schema can have multiple stars, one for each of your fact tables.
Note that a dimensional table might be related (shared) to more than one fact table.
No comments:
Post a Comment