Handling of multiple date in data model

[anand_61]

Hi ,

I have 2 fact table and from 1st fact table we are getting 3 date type field.(e.g: closed date ,open date ,delivery date ) and from fact table 2 we are getting different 2 date type fiels.

We have a master calender.

How can we make a data model with this.

Any leads will be appreciated.

[ogautier62]

Hi,

look at this :

Canonical Date

regards

[shiveshsingh]

You can use interval match function to match the dates and then link it with the calendar.

can you share some sample data to work upon?