Fact table - activity(time and attendance)

[SnowShine429]

Hi everyone,

I am creating a fact table off a transaction table that records employee activity(punch-in time, punch-out time etc). Business wants to track the hours each employee works. The transaction table has a start time and end time for each employee per day. Should I calculate hours each days and store in the fact table or should I bring the time stamps and date into the fact table? What factors decide the approach we need to take? I am assuming there are pros and cons of both the approaches.

Thanks in advance for the advice.

[ngalemmo]

I would do both. Having the timestamps is useful and doing the elapsed time calculation and storing the value makes life easier for users and reduces chance of error.