Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 12634 Views
- HSBC, I also Faced
- E-Mail Answers
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
explain about citrix scheduling tool in datastage
Explain entity, attribute and relationship in datastage?
Define Job control?
Could anyone give brief explanation bout datastage admin
What is a folder? Difference types of stages?
AGGREGATOR default datatype
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
If you want to use a same piece of code in different jobs, how will you achieve this?
client know skid info?
What all are the different way to run a job?
Can you explain link buffering?
How many Key we can define in remove duplicate stage?
Define meta stage?
What is ibm datastage flow designer?
Can you filter data in hashed file?
