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
- 14226 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 |
Tell me the syntax of Configuration file?
On which Dimension Table you implemented SCD Type in your Project
what is hash file
source contains 2 columns comes to target 4 columns how
where we use column generator stage in real time scenario?
what is .dsx files
What is the use of datastage designer?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Hai..,in datastage how to explain project in interview?please explain any domain please.
What could be a data source system?
What is the difference between Link collector and Funnel Stages?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
Teradata 
