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 is the precedence of stage variables,derivations, and constraints?

604

How a server job can be converted to a parallel job?

635

What is aggtorec restructure operator?

755

Name the different types of Lookups in Datastage?

741

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

2755

Describe the architecture of datastage?

582

Triggers,VIEW,Procedures

811

What is a quality stage in datastage tool?

640

What is active and passive stage?

897

What is the difference between passive stage and active stage?

834

Can you filter data in hashed file?

3360

What all the types of jobs you developed?

682

Explain the situation where you have applied SCD in your project?

1572

Demonstrate experience in maintaining quality process standards?

1957

What are the different type of jobs in datastage?

620