Date-time analysys for call center agents modeling

[IvanR]

Hello!
Help me please to decide which approach is better for model performance and an easy way to analyze data for the contact center.
Separate date time column and create date integer key and time integer key in fact table , after that connect these keys to separate dimDate and dimTime tables? Won't this approach complicate analyses (slow and complicated measures)?

or leave one DateTime column fact table as is?

Working hours, login time, etc. have to be calculated for each person and aggregated.

Thank you in advance for you answers and explanations!

[lbendlin]

The literature says to use separate date and time calendar tables to reduce the cardinality.  Even with the added measure logic overhead that is still significantly faster than if you had to deal with a datetime calendar table.