ExtMergeJoin won't handle left outer join

Hi,

I can’t seem to make Ext_Merge_Join component hanlde ‘left outer join’ nor ‘allow slave duplicates’ options. When using either of these options, the component won’t output the expected data.

Especially, if join key has a null value on some rows, this will block the component.

Ext Hash Join works just fine, but is much slower when volume grow in size…

Is this a known problem, or am I missing something ?

Franck

Hi, I tried to recreate your problem but everything works correctly: there is no error message and data are joined properly. Can you send more info about the problem (graph and data probe)?
With regards
Agata Vackova