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)…