Capture orphan rows during MERGE_JOIN

dnassirp

• October 07, 2008 00:00

• Answered

Follow

Is there a way to capture 'orphan' rows during MERGE_JOIN? Perhaps write those records to a separate output port? For instance, if I specify leftOuter for the MERGE_JOIN, I still need to capture those rows in the slaves that don't match up to a driver record. Is this possible?

Thanks.

• 

  avackova

  • October 08, 2008 06:48

  0

  Comment actions Permalink

  No, you can't send thees records to separate output port. But when you specify fullOuter, you can then filter such records.
• 

  dnassirp

  • October 08, 2008 16:47

  0

  Comment actions Permalink

  That's what I was just considering. OK, I think we'll be able to use that approach.
  
  Thanks!

Please sign in to leave a comment.