Daily Mapping table

Thanks Anonymous  for the advise, however we have thousands of employees so it will be a huge job to set up and maintane the dimention table based on employee instead of teams.

Another thing I'm not sure how this works, do you need to create a new employeeID for the same employee everytime there is a sturcture change? Normally the employeeID will be associated with the same  employee for their whole career  in our company , if you create a new employee ID it won't create a relationship with the fact  table since in the fact table there will only be one fixed employeeID for each employee. For example in fact table the employee ID for Tom is 1001, if you create another employee ID 1005 for Tom in  dimention table it will not map to the fact table since they have different employee ID.