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
- 14045 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 the use of materialized view?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Where the datastage stored his repository?
Terminate Activity
Does datastage support slowly changing dimensions ?
Name the different sorting methods in datastage.
Define meta stage?
how to implement scd2 in datastage 7.5 with lookup stage
What is the differentiate between data file and descriptor file?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How can you write parallel routines in datastage PX?
AGGREGATOR default datatype
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Difference between in process and inter process?
how to abort the job its matain duplicates?
