synthetic key issue on interval match

[#1]

hello all,

is there a way to remove synthetic key issue on interval match ??

thanks

charitha

[arulsettu]

use left join or

can you post your script

[awhitfield]

Hi Lakshmi,

please see the attached thread

interval match and synthetic key

HTH Andy

[#4]

Hi,

there are some discussion on this topic, concluding that this is a synthetic key created by purpose and not harming.

Please check

IntervalMatch