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
- 12665 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
Difference between sequential file and data set?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many Key we can define in remove duplicate stage?
How do you register plug-ins?
how to export or import the jobs in .ISX file
which r the connectors used in san?
Define Routines and their types?
How do you run datastage job from the command line?
What are the primary usages of datastage tool?
Name the different types of Lookups in Datastage?
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
What is the difference between account and directory options ?
How a server job can be converted to a parallel job?
What are the different types of lookups in datastage?
How the ipc stage work?
