the diagram is not of the dimensions and fact table but of the OLTP at the second stage.

Stage 1. RawData into generic table

Stage 2. Data cleaned and loaded which should transform to dimensions.

The fact table data is has also been loaded into a table with a uniquie key as well.

It is a statement of facts about people.

The Fact Table will be exactly that.

However, I will also need to aggregate on Department, StaffGroup etc.

There will be KPIs and Trends for each of the topics. But that is the easy/ fun part (I hope :w00t:)

Hope this helps.