Fact table as many to many join

View previous topic View next topic Go down

Fact table as many to many join

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

View user profile

Back to top Go down

Re: Fact table as many to many join

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Fact table as many to many join

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

View user profile

Back to top Go down

Re: Fact table as many to many join

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