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

Fact table as many to many join

2 posters

Go down

Fact table as many to many join Empty Fact table as many to many join

Post  Dean2004 Tue Jan 17, 2012 6:08 pm

Grateful for any advice to a newbie designing his first data warehouse. This is an educational institution where employees can occasionally be employed in more than one job at the same time, while jobs can of course be held (but only at different times) by different employees. Am I right in thinking that a fact table with a grain of the employment situation each day is perfectly adequate for modelling this many to many join and I don't need to create a helper table between the two dimensions as well?

Dean2004

Posts : 2
Join date : 2012-01-17

Back to top Go down

Fact table as many to many join Empty Re: Fact table as many to many join

Post  ngalemmo Tue Jan 17, 2012 7:15 pm

You can handle it by including job in the grain and storing an FTE value for that job in the fact table (so an employee holding two jobs will not be over counted). An employee with multiple jobs would appear in multiple rows at a given point in time. This would avoid having to deal with a multivalued dimension and having to use a bridge.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Fact table as many to many join Empty Re: Fact table as many to many join

Post  Dean2004 Wed Jan 18, 2012 6:27 am

That's great, thanks very much indeed for the trouble taken to reply and so quickly!

Dean2004

Posts : 2
Join date : 2012-01-17

Back to top Go down

Fact table as many to many join Empty Re: Fact table as many to many join

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