Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Multivalued Dimension & Bridge Table

2 posters

Go down

Multivalued Dimension & Bridge Table Empty Multivalued Dimension & Bridge Table

Post  abercrombieande Wed Dec 28, 2011 11:49 am

In the example of having multiple diagnoses per bill in several of the Kimball books why is a bridge table needed? I know its suppose to always be a 1 to many relationship between the dimensions and the fact table. Why cant I just create a table like this and join it to the fact table? Thanks for your input

Dim Diagnosis
--------
Diagnosis Group --Key in fact table
Diagnosis Name
Weight Factor

abercrombieande

Posts : 2
Join date : 2011-12-28

Back to top Go down

Multivalued Dimension & Bridge Table Empty Re: Multivalued Dimension & Bridge Table

Post  ngalemmo Wed Dec 28, 2011 5:50 pm

It is customary to have a diagnosis dimension. Usually their are attributes relating to a diagnosis that the business may use for analysis, plus you may need such a dimension for conformance to other facts, integration of different coding systems, and so forth. The structure you propose does not support such functionalities.

Besides, the table you describe will be very large... it will be many orders of magnitude larger than the diagnosis dimension. Do you really want to repeat the diagnosis name 1000's of times in the proposed table and at the same time limit your ability to perform analysis on diagnosis?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Multivalued Dimension & Bridge Table Empty Re: Multivalued Dimension & Bridge Table

Post  abercrombieande Thu Dec 29, 2011 9:20 am

Thanks for the information. I guess I didn't really think of using the diagnosis dimension again in another start schema as a conformed dimension. I also under stand the point about not having redundant attribute columns.

In my situation even if I combined the groups with the details we are only talking a few thousand rows and there are only two attribute columns, code and desc. I think this is why I did not see the full picture.

abercrombieande

Posts : 2
Join date : 2011-12-28

Back to top Go down

Multivalued Dimension & Bridge Table Empty Re: Multivalued Dimension & Bridge Table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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