I want capture UnMatched records from Primary source and secondary source in JOIN stage?
- 3 Answers
- 12936 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
in oracle target stage when we use load option and when we use upsert option?
What are routines in datastage? Enlist various types of routines.
What are transforms and what is the differenece between routines and transforms?
What is datastage engine?
How to manage date conversion in Datastage?
What is the difference between operational data stage (ods) and data warehouse?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the steps required to kill the job in Datastage?
Difference between in process and inter process?
Differentiate between datastage and informatica?
What is size of a transaction and an array means in a datastage?
How do u convert the columns to rows in datastage?
how can we create rank using datastage?what is the meaning of rank?
How can you write parallel routines in datastage PX?
how to sort two columns in single job in datastage.
