interval match

[jim_chan]

Hi guys,

I was working on intervalmatch on sales. min_sales and max_sales. Now, there's a synthetic key. How can i solve it?

Rgds,

Jim

[jim_chan]

nope.

[ToniKautto]

If you get the accurate numbers from the data model, there is no need to remove the synthetic key. If you are not sure you get the accurate numbers, then it is safer to remove the synthetic key. Synthetic key as such is not a problem, but depending on the data relations it can cause unexpected results.

[jim_chan]

i thought so  too. but thanks All.!!!

[#5]

Use Left join.. If you concern about memory usage then use optimisation techniques.