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

one parent many entities - fact table

3 posters

Go down

one parent many entities - fact table Empty one parent many entities - fact table

Post  KKumar Fri Jul 29, 2011 4:42 pm

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



KKumar

Posts : 22
Join date : 2011-07-29

Back to top Go down

one parent many entities - fact table Empty Re: one parent many entities - fact table

Post  ngalemmo Sun Jul 31, 2011 12:41 pm

Seems reasonable.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

one parent many entities - fact table Empty Re: one parent many entities - fact table

Post  KKumar Mon Aug 01, 2011 10:30 am

Thanks

KKumar

Posts : 22
Join date : 2011-07-29

Back to top Go down

one parent many entities - fact table Empty Re: one parent many entities - fact table

Post  cjrinpdx Mon Aug 01, 2011 2:46 pm

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

Back to top Go down

one parent many entities - fact table Empty Re: one parent many entities - fact 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