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?
Answer Posted / ra
Simple.
ano,aname,amt
1,a,1000
2,b,2000
3,c,3000
column derivation write like this (amt+2000) then we will get o/p
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
Differentiate between odbc and drs stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the difference between odbc and drs stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Explain Quality stage?
What is the difference between passive stage and active stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How to convert RGB Value to Hexadecimal values in datastage?
How complex jobs are implemented in datstage to improve performance?
Which algorithm you used for your hashfile?
why do u need the IOS upgradation in a FC switch
What is a merge in datastage?
Describe the architecture of datastage?
how to delete one row in target dataset