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
- 7611 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
Differentiate between validated and Compiled in the Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Differentiate between hash file and sequential file?
What are the different types of lookups in datastage?
What is aggtorec restructure operator?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Different ways a project can be moved to production ?...example ….export-import and Version control.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What can we do with datastage director?
why do u need the IOS upgradation in a FC switch
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Differentiate between odbc and drs stage?
what is use of SDR function?
explain about citrix scheduling tool in datastage
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
