Interested to Buy Any Domain ? << Click Here >> for more details...
I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?
- 3 Answers
- 7484 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra swain(hara)
mapping for above job
fileA---->joinstage---->transformer------->dataset1
^ ------>dataset2
|
|
fileB
go to joinstage ,take type of join is fullouter join,
then copy the i/p column to o/p link ,goto transformer stage
u 'll found 2 constraint tab ,in 1st constraint tab write
leftRec_column<>rightRec_column And LeftRec_column<>0,
similarly in 2nd constraint tab write
leftRec_column<>rightRec_column And RIGHTRec_column<>0
then copy only LeftRec_column to dataset1
and copy only RightRec_column to dataset2
i think u definitly get the correct answer
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How a source file is populated?
Demonstrate experience in maintaining quality process standards?
Explain entity, attribute and relationship in datastage?
Could anyone give brief explanation bout datastage admin
How do u convert the columns to rows in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How many types of hash files are there?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is difference between join, merge and lookup stage?
How do y read Sequential file from job control?
What is ds designer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How many types of stage?
What are the types of views in datastage director?
