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
- 14341 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 are the functionalities of link partitioner and link collector?
Can you highlight the main features of ibm infosphere information server?
How one source columns or rows to be loaded in to two different tables?
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between hash file and sequential file?
Why do we use link partitioner and link collector in datastage?
how to sort two columns in single job in datastage.
What is the purpose of interprocessor stage in server jobs?
What are the functionalities of link collector?
What are the types of containers?
What is a quality stage in datastage tool?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Is possible to create skid in dim,fact tables?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
how to add a new records into source?
