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?
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
Event Participation
which shares some dimensions with the Event
or has the EventSequenceNumber
as a degenerate dimension.