The logic is not clear to me. Why is record 20|YYY from source 1 pushed to the target while record 20|ZZZ from source 2 is not?

Please explain in a bit more detail.

And yes, probably you will have to use an Expression transformation to flag records which exist only in one of the two source streams, so a JNR with Full Outer Join is probably the way to go.

Regards,

Nico

Hi,

Please use below approach to achieve the result.

Thanks,

I would change this slightly; it's safer to assume that the ID is the "real" primary key than to rely on the NAME field always having the correct value, so both output ports of the EXP should look like this:

  IIF( IsNull( ID), ... , ...)

So for O_ID it should read like this:

  IIF( IsNull( ID), ID1, ID)

And for O_NAME it should read like this:

  IIF( IsNull( ID), NAME1, NAME)

This way you have the same selection criterion for all output columns, meaning you preserve the complete record (instead of potentially mixing contents from both records in case one of the fields from the original record is empty).

Besides that many thanks to Deepak for providing the sample mapping!

Regards,

Nico

My humble thanks for your kind words. I'm happy and grateful that this time I was able to help you.

Thanks and kind regards,

Nico