I have a star schema data model where i have 2 fact tables and one link table.i have a complaint dimension which consists of complaint start date and complaint end date and one master calendar which consists of dates.i need to match complaint start date and complaint end date from complaint dimension to master calendar dimension.
i have already tried interval match function.if we do so then there will be link between complaint dimension and master calendar.But our data model is star schema.
