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
- 12826 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / hussy
Hi,
My suggestion is instead of calculating for each column.
Create a stage variable (amt+2000)----> STG1
Call this STG1 in your derivation output amount column.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is staging variable?
What is apt_config in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
Give an idea of system variables.
How do you remove duplicate values in datastage?
What is the purpose of interprocessor stage in server jobs?
in oracle target stage when we use load option and when we use upsert option?
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 are the important features of datastage?
How to read the length of word in unix?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the difference between passive stage and active stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
whom do you report?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
