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
28983 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

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

826

Define oconv () and iconv () functions in datastage?

1471

Name the command line functions to import and export the DS jobs?

1203

How to convert RGB Value to Hexadecimal values in datastage?

4060

what is flow of project?

2061

What is the difference between Datastage 7.5 and 7.0?

1153

What is the method of removing duplicates, without the remove duplicate stage?

1083

Why do we use exception activity in Datastage?

1374

Enlist various types of routines in datastage.

1328

What is the use of datastage designer?

1223

What is the difference between in process and inter process?

1203

How one source columns or rows to be loaded in to two different tables?

1179

What is job control?

1201

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277

how many rows sorted in sort stage by default in server jobs

4053