Data in a fact or dimenzion table or bridge table

View previous topic View next topic Go down

Data in a fact or dimenzion table or bridge table

Post  MK on Fri Apr 05, 2013 6:00 am


Please review how to create a model. I have health care providers belonging to several regional units.
Analysis will need to be varied according to regional units, as well as
which care providers belong to a regional unit

care providers Regional Unit
1000 1
1002 1
1002 2

Is it wise to have a regional unit in the FACT table as a foreign key (Regional Unit dimension) as well as in the table of Care providers.

Is it better to have fk of regional unit in dimension of providers and linked table of Regional unit and Care Providers.
Do I must have bridge table or j just put fk dimension of provider and i have relationship M:M in one table. With olap tool
I can define ralationships in one table.

Best regards and thanks in advance, K


Posts : 16
Join date : 2013-02-04
Location : Slovenia

View user profile

Back to top Go down

Re: Data in a fact or dimenzion table or bridge table

Post  umutiscan on Tue Apr 09, 2013 1:22 am


If you have Care Provider Key in your fact table, you cannot put the regional unit key of that record. Because that provider may belong to more than one Regional Unit.
I have seen some examples that identify one regional unit as "master", and put that "master key" in to the fact table.

But your case is the classical many to many problem and the solution is bridge table between your fact and Regional Unit dimension.


Posts : 51
Join date : 2010-11-26
Age : 36
Location : Istanbul, Turkey

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum