0

I am new in DW and I have a simple question. Imagine that I want to create a DW to analytical CRM.

I have a fact table called Event and I have a dimension called Customer.

The problem is. One event can have N Customers, and one Customer can be in N events.

So the relation between Customer(dimension) and Events(fact) are NxN. Is that schema is correct? If not, what schema will be better for this case?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
p.magalhaes
  • 7,595
  • 10
  • 53
  • 108
  • Is Event both fact & dimension? You presumably have a table between Customer and Event if there's a many-many mapping. – Will A Jun 04 '11 at 04:55

1 Answers1

2

In essence a fact table is a many-to many table in between dimensions. So in your case,

  • Event table is a dimension table.

OR

  • There is another fact table Event Participation which shares some dimensions with the Event or has the EventSequenceNumber as a degenerate dimension.
Damir Sudarevic
  • 21,891
  • 3
  • 47
  • 71