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
- 12439 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 the difference between server job and parallel jobs?
Explain connectivity between datastage with datasources?
What a datastage macro?
What is size of a transaction and an array means in a datastage?
How do you schedule or monitoring the job?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How the ipc stage work?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the different types of lookups in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
Name the third party tools that can be used in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the functionalities of link collector?
What is the precedence of stage variables,derivations, and constraints?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
