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
- 11265 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
How to read the length of word in unix?
What are the some differences between 7.x and 8.x version of datastage?
How and where you used hash file?
Can you highlight the main features of ibm infosphere information server?
What are the main features of datastage?
explain about citrix scheduling tool in datastage
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 are the types of containers and how to create them?
Define APT_CONFIG in Datastage?
CHANGE CAPTURE
What all are the different way to run a job?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Different ways a project can be moved to production ?...example ….export-import and Version control.
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
On which interface you will be working as a developer?
