Fact Table Foreign Key reference question
3 posters
Page 1 of 1
Fact Table Foreign Key reference question
I have a fact table Called "Injury" I have now had to bring in additional data which includes body part and nature of the injury information related to the injury.
So and Injury can have 0,1 or more body parts. I originally was going to make a table called BodyPartInjuryNature have a foreign key from the Injury Fact table. Is that the correct way or would there be a better option for design ?
Thank you,
So and Injury can have 0,1 or more body parts. I originally was going to make a table called BodyPartInjuryNature have a foreign key from the Injury Fact table. Is that the correct way or would there be a better option for design ?
Thank you,
mru22- Posts : 34
Join date : 2011-06-14
Re: Fact Table Foreign Key reference question
I don't think you can have body parts FK in the injury fact table which is at injury level and body part is a multivalued dimension. I would create a bridge table that holds both FKs so that you are able to drill down from injury to body parts
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Re: Fact Table Foreign Key reference question
The grain is different. Your current fact table "Injury" is one row per injury. Your new fact table would be one row per injury and body part. Your new fact table could be a factless fact table where you just pull in the related dimensions (body part, person, injury nature).
cjrinpdx- Posts : 51
Join date : 2011-07-14
Location : Portland, OR
Similar topics
» Fact surrogate key as foreign key in another fact table
» Factless fact table with null foreign keys
» fact table's foreign key related to multiple dimensions
» Derived Fact table with additional measures / foreign keys ... ?
» Fact Table with huge number of Blank (or Empty) foreign keys
» Factless fact table with null foreign keys
» fact table's foreign key related to multiple dimensions
» Derived Fact table with additional measures / foreign keys ... ?
» Fact Table with huge number of Blank (or Empty) foreign keys
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum