you are use transformer if (Marks > 50 or 40 <Marks ) then rank=2 e

Hi Friends,
I have a input data like,
class_id Marks
101 50
101 60
101 40
102 90
102 35

And i want my output data like
class_id Marks Rank
101 50 2
101 60 1
101 40 3
102 90 1
102 35 2

how to do this in datastage?

Question Posted / amulya kumar panda

8 Answers
28281 Views
Cognizant, HCL, TIAA CREF, I also Faced
E-Mail Answers

Answer Posted / amulya kumar panda

you are use
transformer if (Marks > 50 or 40 <Marks ) then rank=2 else
if Marks > 60 then rank=1 else rank=4

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What could be a data source system?

939

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2002

what is the use of materialized view?

1485

What is the difference between hashfile and sequential file?

1185

what is the custome stage in datastage? how can we impliment that one? plz tell me

2314

How do you import and export data into datastage?

1165

What are sequencers?

1055

Can you filter data in hashed file?

3720

What are the areas of application?

1090

What are the different common services in datastage?

1213

What is meta stage?

1128

Explain connectivity between datastage with datasources?

938

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2168

Describe the architecture of datastage?

949

What is difference between join, merge and lookup stage?

1035