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
- 12438 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / saran
using TFM stage we can get o/p like this
in TFM stage write derivation on column level
i.e link.column+1000
| Is This Answer Correct ? | 0 Yes | 13 No |
Post New Answer View All Answers
What is the difference between in process and inter process?
Can you explain engine tier in information server?
What is oci?
Where do you see different stages in the designer?
Can you highlight the main features of ibm infosphere information server?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Can you filter data in hashed file?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Define Data Stage?
what is use of SDR function?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are datastage sequences?
What are the types of views in datastage director?
What is ds designer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
