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
- 12836 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
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the command line function to import and export the ds jobs?
What is oci?
What is the difference between operational data stage (ods) and data warehouse?
How to RD using transformer?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is quality stage?
Can you explain engine tier in information server?
What is the difference between orabulk and bcp stages?
In Datastage, how you can fix the truncated data error?
What is a folder? Difference types of stages?
What is difference between join, merge and lookup stage?
Enlist various types of routines in datastage.
Explain the situation where you have applied SCD in your project?
What are the different types of lookups in datastage?
