Capture orphan rows during MERGE_JOIN

CloverDX Platform
1

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.

2

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

3

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

Thanks!