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
- 14194 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is a quality stage in datastage tool?
What are iconv and oconv?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is merge stage?
Name the command line functions to import and export the DS jobs?
What are the important features of datastage?
Differentiate between operational datastage (ods) and data warehouse?
Whats difference betweeen operational data stage (ods) and data warehouse?
Is the value of staging variable stored temporarily or permanently?
what is flow of project?
What is staging variable?
Describe the architecture of datastage?
Why we use surrogate key?
what is the use of skid in reporting?
What is the use of datastage designer?
