Interested to Buy Any Domain ? << Click Here >> for more details...
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
- 3 Answers
- 14083 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the difference between datastage and datastage tx?
Is the value of staging variable stored temporarily or permanently?
What are the functionalities of link collector?
how does work server jobs?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
data stores in which location while using data set stage as the target?
how to call sequential generator in datastage?
how CAN we remove duplicates in dataset?
Teradata 
