I want capture UnMatched records from Primary source and secondary source in JOI

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

Question Posted / subbuchamala

3 Answers
12946 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I want capture UnMatched records from Primary source and secondary source in JOIN stage?..

Answer / subbuchamala

SRC1, SRC2=====>JOIN====>TGT

in JOIN stage, take full outer join.
in Filter/Transformer stage, give condition as SRC1.KEY is null then unmatched records from SRC2.
SRC2.KEY is null then unmatched record from SRC1.

Is This Answer Correct ?

8 Yes

0 No

I want capture UnMatched records from Primary source and secondary source in JOIN stage?..

Answer / subhash (subbuchamala)

SRC1, SRC2====>JOIN====>TGT

in JOIN stage, select the full outer join.
in the Filter/Transformer stage, give condition as SRC1.KEY is null then unmatched records from SRC2.
SRC2.KEY is null then unmatched record from SRC1.

Is This Answer Correct ?

3 Yes

0 No

I want capture UnMatched records from Primary source and secondary source in JOIN stage?..

Answer / ankit gosain

Hi,

You can achieve the unmatched records from Primary and
Secondary with the help of Full Outer Join using Join Stage.

source1----->Join Stage------>Transformer------>Target
|
|
|
source2-----------

Full Outer Join on Source1.key=Source2.key

Now, in Transformer Stage, write in constraint tab for
source1, <any coulum of source2> IsNull, to collect the
unmatched records of source1.
&, write in constraint tab for source2, <any coulum of
source1> IsNull, to collect the unmatched records of
source2.

If you have any other doubt or query, mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?

3 Yes

1 No

Post New Answer