Star schema [fact 1:n dimension]...how?
- by Mike Gates
I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema:
If I have a fact table where a fact record naturally has a one-to-many relationship with a single dimension, how can a star schema be modeled to support this? For example:
Fact Table: Point of Sale entry (the
measurement is DollarAmount)
Dimension Table: Promotions (these
are sales promotions in effect when a
sale was made)
The situation is that I want a single Point Of Sale entry to be associated with multiple different Promotions. These Promotions cannot be their own dimensions as there are many many many promotions.
How do I do this?