7 different dates to seconds precision
4 posters
Page 1 of 1
7 different dates to seconds precision
We store call center data and each call has 7 different dates associated to it. Example is CallTime, connectTime, FinishTime etc which may be just seconds apart making it important to store the dates till seconds and if possible milli seconds precision. Does these dates go into dimension table or a fact table?
If its a role playing dimension, do I need 7 dates and 7 time id's in fact table?
If its a role playing dimension, do I need 7 dates and 7 time id's in fact table?
anusha.jalla@gmail.com- Posts : 3
Join date : 2012-04-03
RE: 7 different dates to seconds precision
Hi,
one approach that you can have is create two dimension , one will store the dates and onw will store the time dimension ( that could be at the hour, minute or secound level).
In the fact table you will have one FK key to date and the other to time.
thanks
Himanshu
one approach that you can have is create two dimension , one will store the dates and onw will store the time dimension ( that could be at the hour, minute or secound level).
In the fact table you will have one FK key to date and the other to time.
thanks
Himanshu
hkandpal- Posts : 113
Join date : 2010-08-16
Re: 7 different dates to seconds precision
Does the time of day have attributes that you wish to associate with it? If no, then just store the timestamp as a degenerate dimension in the fact.
If there are attributes, then create a dimension. However, you may still wind up storing the timestamp as a degenerate dimension if the precision requirements for the value exceed the precision of the dimension.
If there are attributes, then create a dimension. However, you may still wind up storing the timestamp as a degenerate dimension if the precision requirements for the value exceed the precision of the dimension.
Re: 7 different dates to seconds precision
Thanks for the quick reply. I think degenerate dimension will suit my use case more due to precision level uncertainty at this point.
anusha.jalla@gmail.com- Posts : 3
Join date : 2012-04-03
Re: 7 different dates to seconds precision
I don't see how millisecond data is useful from a reporting standpoint. I've done reporting on call center data and 1/10th of a second is about all that is meaningful. Also, timestamps are great, but for analysis purposes, they will want the ability to break down by time of day. A time of day table with 1/10th second data for an entire day is not that large. I also precalculated time differences because they were always doing analysis by how long certain steps took (like hold time, time to disconnect, ect) and it wasn't very fast calculating on the fly.
TheNJDevil- Posts : 68
Join date : 2011-03-01
Similar topics
» Fact with eff / exp dates referencing dimension with eff / exp dates
» Looking for BI performance standards (response time)
» Null value for dates
» Dates as a UOM?!
» Dates in many dimensions
» Looking for BI performance standards (response time)
» Null value for dates
» Dates as a UOM?!
» Dates in many dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|