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

What is the difference between informatica and datastage?

650


Have you have ever worked in unix environment and why it is useful in datastage?

643


How you can fix the truncated data error in datastage?

1189


client know skid info?

1631


What is size of a transaction and an array means in a datastage?

737






What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1633


Can you explain tagbatch restructure operator?

697


Can you filter data in hashed file?

3339


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

766


What are the stages in datastage?

635


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3309


Can you define merge?

662


Describe stream connector?

826


Why fact table is in normal form?

666


What are the difference types of stages?

619