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
- 14216 Views
- TCS, I also Faced
- E-Mail Answers
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 |
in oracle target stage when we use load option and when we use upsert option?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
Where the datastage stored his repository?
Differentiate between operational datastage (ods) and data warehouse?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
How can we achive parallelism
how to configure databases through datastage
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
what is A Datastage?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
Which commands are used to import and export the datastage jobs?
Can you explain link buffering?
Teradata 
