Removing synthetic keys when using Interval Match

[#1]

Hi All,

I am using an interval match function and this is leading to the formation of synthetic keys, which I believe is creating a great performance issue. I saw a couple of post on this already but not able to get a correct solution.

So , I have a table Table1 which has inline data and 3 fields:

Table1

LOAD * INLINE [

StartRange, EndRange, DateRange

09/27/2004, 09/25/2005, FY-05

09/26/2005, 09/24/2006, FY-06

09/25/2006, 09/30/2007, FY-07

];

and I'm using an interval match function like this

IntervalMatch(Calendar.DATE) Load StartRange, EndRange  Resident Tabel1;

So, just using the calendar date to interval match with the inline data table above. But this results in a synthetic key formation which I need to remove. Any recommendations.

Thanks in advance.

[johnw · Accepted solution]

Left join the intervalmatch onto Table1 would be my first guess.

[#3]

It worked . Thanks a lot John.

[Anonymous]

Thats correct answer. Thank you