Hy from Portugal,
Well, here's my case to see if you can help me:
We are trying to build a DW in our Healthcare institution, however we are facing a challenge and we are not solving it using many-to-many dimension ( The technology is Microsoft).
Fact Patient Hospitalization - Each patient hospitalization generates an EPISODE of hospitalization (EPISODE_ID) WHICH IS UNIQUE ....in the relational fact table we have the EPISODE ID COLUMN and also a TOTAL_EPISODES
column wich is always equal to "1" because, after dimensional modelling, we will have a measure that is "sum of episodes".
EPISODE_ID is a foreign key to the EPISODE_ID field of Patient Hospitalization Dimension
Patient Hospitalization Dimension
-> EPISODE_ID (primary key)
-> DESCRIPTION ( day or night - describes if the episode ocurred during the day or during the night)
Fact Patient Claims (this fact will be the basis for the measure "sum of claims")
This table has the fields
-> CLAIM_ID ( it is always unique (p
View Complete Post