CODEWITHSUNDEEP
data-warehouseolap
Mike Gates
Mike Gates

Reputation: 1904

Star schema [fact 1:n dimension]...how?

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:

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?

Upvotes: 2

Views: 450

Answers (1)

ETL Man
ETL Man

Reputation: 255

Use bridge table

fact table=>promotion group dimension=>promotion group bridge table=>promotion

Read Kimball books' they help a lot ;-)

Upvotes: 2

Related Questions