Multivalued Dimension & Bridge Table
2 posters
Page 1 of 1
Multivalued Dimension & Bridge Table
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
Dim Diagnosis
--------
Diagnosis Group --Key in fact table
Diagnosis Name
Weight Factor
abercrombieande- Posts : 2
Join date : 2011-12-28
Re: Multivalued Dimension & Bridge Table
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?
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?
Re: Multivalued Dimension & Bridge Table
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.
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
Similar topics
» Adding mini dimension to bridge table
» bridge table and junk dimension on customer dimension (bank/credit union)
» Tip #136 Adding a Mini-Dimension to a Bridge Table: What if you can't split the dimension?
» Multvalued dimension bridge table and SCD 2 dimension
» Degenerate Dimension - Bridge Table
» bridge table and junk dimension on customer dimension (bank/credit union)
» Tip #136 Adding a Mini-Dimension to a Bridge Table: What if you can't split the dimension?
» Multvalued dimension bridge table and SCD 2 dimension
» Degenerate Dimension - Bridge Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum