Hi, My suggestion is instead of calculating for each column. Create a

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?

Question Posted / hussy

5 Answers
12848 Views
HSBC, I also Faced
E-Mail Answers

Answer Posted / hussy

Hi,

My suggestion is instead of calculating for each column.

Create a stage variable (amt+2000)----> STG1

Call this STG1 in your derivation output amount column.

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2416

What is datastage?

1133

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

1191

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

3811

What are the stages in datastage?

1138

what is ds administrator used for?

1222

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1468

What are the repository tables in datastage?

1353

Where do the datastage jobs get stored?

1271

What are system variables and sequencers in datastage

1183

What are the components of ascential data stage?

1243

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1462

Name the different types of Lookups in Datastage?

1313

What are the different layers in the information server architecture?

1177

Difference between data warehousing and olap?

1151