I want capture UnMatched records from Primary source and secondary source in JOIN stage?
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 |
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How you Remove the Dataset in Unix?
what is the difference between the active datawarehouse and datawarehouse
Pls tell me what is troubleshooting in datastage view?
Explain how a source file is populated?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
how to run jon in unix back round process what is command use in runing a job?
Name the different types of Lookups in Datastage?
How to generate surrogate key without using surrogate key stage?
Display all files which have size more 3KB in given directory/folder.
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
Differentiate between datastage and datastage tx?