Forum Discussion
Helper IDate key Data type for Date Dimension
Hi ntimmerman
AnalyticPulse Thank you very much for your prompt reply. Allow me to add something here.
Using an integer date key is a traditional approach where dates are represented in a format. This method is beneficial for performance reasons, as joining on integers is generally faster than dates.
However, it can make date calculations more complex, as you’ve noticed with the function not working properly with integer keys.
On the other hand, a Date data type key is more intuitive and aligns with the natural representation of dates.
Given your experience with the function not working with an integer column, it seems that using a Date data type might be more suitable for your needs.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ntimmerman
AnalyticPulse Thank you very much for your prompt reply. Allow me to add something here.
Using an integer date key is a traditional approach where dates are represented in a format. This method is beneficial for performance reasons, as joining on integers is generally faster than dates.
However, it can make date calculations more complex, as you’ve noticed with the function not working properly with integer keys.
On the other hand, a Date data type key is more intuitive and aligns with the natural representation of dates.
Given your experience with the function not working with an integer column, it seems that using a Date data type might be more suitable for your needs.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThank you Anonymous and AnalyticPulse ! I will do some more experimenting but will probably change to using a date field as date key. Thanks again