Fact table as many to many join
2 posters
Page 1 of 1
Fact table as many to many join
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
Re: Fact table as many to many join
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.
Re: Fact table as many to many join
That's great, thanks very much indeed for the trouble taken to reply and so quickly!
Dean2004- Posts : 2
Join date : 2012-01-17
Similar topics
» Connect two fact table
» Right Outer Join with Fact table
» What Dimensions should / could we join to our accumulating fact table?
» How do I join a role playing date dimension view with a Fact table in SQL Server?
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Right Outer Join with Fact table
» What Dimensions should / could we join to our accumulating fact table?
» How do I join a role playing date dimension view with a Fact table in SQL Server?
» '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