Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Differentiate between odbc and drs stage?

995


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2443


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2175


What is the difference between odbc and drs stage?

1042


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2402


Explain Quality stage?

1087


What is the difference between passive stage and active stage?

1412


Different ways a project can be moved to production ?...example ….export-import and Version control.

2385


How to convert RGB Value to Hexadecimal values in datastage?

3926


How complex jobs are implemented in datstage to improve performance?

958


Which algorithm you used for your hashfile?

1120


why do u need the IOS upgradation in a FC switch

2222


What is a merge in datastage?

1198


Describe the architecture of datastage?

949


how to delete one row in target dataset

3061