Fact table - activity(time and attendance)

View previous topic View next topic 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.

SnowShine429

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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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