Forum Discussion
Dim_Date join with multiple fact date column
Not clear. But make sure that both table are joined on Date column with date table having no time. Also, all dates are cover in date dimension
Not clear. But make sure that both table are joined on Date column with date table having no time. Also, all dates are cover in date dimension
if i dnt join on datetime, how can i extract hourly data
Best practices want the Dim_Date to be a list of distinct days with no gaps, with no time.
In this way you will be able to use it as a calendar table for your model and to use all the Time Intelligence functions.
In your fact you should calculate the date and link it the Dim_Date with a 1:M relationship that goes from Dim_Date to Fact.
understood now. created calendar and hour table and joined the timestamp with facts