I have a sickness Fact table, with a record for each day each employee was sick. I also have 2 dimension tables, employee and Date.
I want to create ages ranges for the age an employee has on each sick day in the fact table. I solved it by adding an age and age-range column tot the sickness fact table (difference between sickday date and birthdate). After that I created a dimension
from this sickness fact table age range columns. But I think the birth date and the age ranges should not be in the fact table, so it works, but in my opinion it is not the way it should be...
So what is the best way to solve this? btw i'm using sql 2008 Standard.
Thanks in advance
View Complete Post