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

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

More Data Stage Interview Questions

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  


what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,


Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,


1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,


which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,






i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,


What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


What is mapping?

3 Answers  


what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,


In one project how many shared containers are created?

3 Answers   NTT Data,


Categories