Fact table - activity(time and attendance)

Go down

Fact table - activity(time and attendance)

Post  SnowShine429 on Fri Jul 25, 2014 2:38 am

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.


Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Fact table - activity(time and attendance)

Post  ngalemmo on Fri Jul 25, 2014 7:41 am

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.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum