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
12630 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 many types of hash files are there?

1178

what is flow of project?

1999

How do you start developing a datastage project?

1103

Can you explain repository tables in datastage?

1403

What is the difference between informatica and datastage?

1218

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

3746

What are the difference types of stages?

1211

What is the flow of loading data into fact & dimensional tables?

1062

What is process model?

1972

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

930

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

What are the types of hashed files in data stage

1106

Can you explain kafka connector?

1306

What a datastage macro?

1056

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2462