ExtMergeJoin won't handle left outer join

oldforum

• July 16, 2007 00:00

• Answered

Follow

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

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.