Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
groundhog
Starting Member
9 Posts |
 Posted - 2010-03-25 : 08:53:23
|
| Hello,My client has the following requirements:Dimension 1 Employees: Name, Birth date, Department Dimension 2 Departments: Department NameThe client needs to report the following questionsWhat is the current exact age (years, Months, Days) of employee X?What was the age of the employee X on (filter date)?What was the average age of department X employees on (filter date)? Based on the above, what is the best data warehouse design? |
|
|
|
|
|
Data warehouse design - Age challenge