title: Data warehouse type 2 scd Employee dimension and HR Facts (Kimball's)
body: <p>I'm following the "Data Warehouse Toolkit" book by Kimball and I'm getting confused with an example of an employee dimension and a HR snapshot fact table.</p>
  
  <p>Here is a screenshot of the example given in the book:</p>
  
  <p><a href="https://i.stack.imgur.com/Shh8t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Shh8t.png" alt="sreenshot"></a></p>
  
  <p>I'm getting confused with the 'Employee count', 'New Hire Count', 'Transfer Count' and 'Promotion Count' fields. As you can see there is a relationship between the HR fact table and the Employee dimension table but which key would be assigned in the fact table in the case of these count values?. I understand that there could be a 'New Hire Count' at the end of the month and we would have Month Dimension FK in the fact table pointing to that month, but what about the employee dimension key?</p>
  
  <p>I hope I'm making myself clear here, and sorry if somehow this is a dumb question.</p>
  
  <p>Thanks.</p>