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 / karthi

how can u do this in tfm explain

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

client know skid info?

1638


What is difference between server jobs & parallel jobs?

628


How to Remove Duplicate using SQL?

852


What is a ds designer?

646


What are the partitioning techniques available in link partitioner?

1761






how can we create rank using datastage?what is the meaning of rank?

8195


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1145


In Datastage, how you can fix the truncated data error?

645


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1812


What a datastage macro?

642


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

1041


describe the Steps to confiure a Qlogic switch

1944


What is meta stage?

584


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1624


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1755