using TFM stage we can get o/p like this in TFM stage write derivation on

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

Answer Posted / saran

using TFM stage we can get o/p like this
in TFM stage write derivation on column level
i.e link.column+1000

Is This Answer Correct ?

0 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What are the components of ascential data stage?

1189

How do you reject records in a transformer?

1125

What is the purpose of pivot stage?

1168

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167

Explain the importance of surrogate key in data warehousing?

1191

What are the some differences between 7.x and 8.x version of datastage?

1256

What are the components of datastage?

1123

What are constraints and derivations?

1170

Enlist various types of routines in datastage.

1257

What is the purpose of interprocessor stage in server jobs?

2233

What is datastage engine?

1180

What is the difference between in process and inter process?

1149

Difference between in process and inter process?

1240

What are the repository tables in datastage?

1309

Terminate Activity

1281