-
1. Re: To capture records which do not meet the join condition in the same target
Nico Heinze Feb 11, 2020 10:51 PM (in response to inuser511275)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
-
2. Re: To capture records which do not meet the join condition in the same target
inuser511275 Feb 12, 2020 7:10 PM (in response to Nico Heinze)Thanks Nico..My bad
Source 1
10 XXX
20 YYY
Source 2
10 XXX
20 YYY
30 TTT
Target:
10 XXX
20 YYY
30 TTT
after joiner..use an expression to flag rows for null values based on the join condition(am joining on 4 different conditions) and then use a filter transformation?
can you please explain?
thanks
-
3. Re: To capture records which do not meet the join condition in the same target
DEEPAK ARORA Feb 13, 2020 6:14 AM (in response to inuser511275)1 of 1 people found this helpful -
4. Re: To capture records which do not meet the join condition in the same target
Nico Heinze Feb 13, 2020 7:11 AM (in response to DEEPAK ARORA)1 of 1 people found this helpfulI 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
-
5. Re: To capture records which do not meet the join condition in the same target
inuser511275 Feb 13, 2020 9:43 AM (in response to DEEPAK ARORA)Thanks Deepak...it worked
-
6. Re: To capture records which do not meet the join condition in the same target
inuser511275 Feb 13, 2020 12:22 PM (in response to Nico Heinze)Thanks Nico for always helping me and providing 100% solutions.
-
7. Re: To capture records which do not meet the join condition in the same target
Nico Heinze Feb 13, 2020 12:18 PM (in response to inuser511275)1 of 1 people found this helpfulMy 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