one parent many entities - fact table

View previous topic View next topic Go down

one parent many entities - fact table

Post  KKumar on 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

View user profile

Back to top Go down

Re: one parent many entities - fact table

Post  ngalemmo on Sun Jul 31, 2011 12:41 pm

Seems reasonable.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: one parent many entities - fact table

Post  KKumar on Mon Aug 01, 2011 10:30 am

Thanks

KKumar

Posts : 22
Join date : 2011-07-29

View user profile

Back to top Go down

Re: one parent many entities - fact table

Post  cjrinpdx on 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

View user profile

Back to top Go down

Re: one parent many entities - fact table

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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