one parent many entities - fact table
3 posters
Page 1 of 1
one parent many entities - fact table
I have this one table with mutliple child tables which need to be flattened.
Project -< Project Contact (contact are Architect, Owner, developer, etc)
Project -< Project Bldg
If I have a question like 'Show all the bldgs that the Architect have designed', then what would be the posible dimensional model in this case
I was thinking of having one fact table something like this:
ProjectId BldgId ContactId....other facts
Please advise.
Thanks
Project -< Project Contact (contact are Architect, Owner, developer, etc)
Project -< Project Bldg
If I have a question like 'Show all the bldgs that the Architect have designed', then what would be the posible dimensional model in this case
I was thinking of having one fact table something like this:
ProjectId BldgId ContactId....other facts
Please advise.
Thanks
KKumar- Posts : 22
Join date : 2011-07-29
Re: one parent many entities - fact table
Yes you would have a project fact table with building and contact dimensions. Be careful on the project contact (contact dimension). Can a project have more than one contact? Can a project have more than one architect? You may need to create a bridge table to support a M-2-M relationship. Of you could put FK fields in your fact table (ArchitectKey, OwnerKey, DeveloperKey) to link to the contact dimension..
cjrinpdx- Posts : 51
Join date : 2011-07-14
Location : Portland, OR
Similar topics
» Unusual(?) parent/child Fact table design issue
» Multiple Life cycle entities in One dimension table...
» How to Model Single-Table Parent-Child Relational Table in a Dimensional Schema
» How to model fact with optional parent fact?
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Multiple Life cycle entities in One dimension table...
» How to Model Single-Table Parent-Child Relational Table in a Dimensional Schema
» How to model fact with optional parent fact?
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum