If you think ur solution is correct just try out with below input and rech

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

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

Answer Posted / shar

If you think ur solution is correct just try out with below
input and recheck ur solution..
class_id,Marks
101,50
101,60
101,60
101,50
101,40
102,90
102,90
102,35
102,35

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do y read Sequential file from job control?

16080

What are some different alternative commands associated with "dsjob"?

1216

Is it possible to query a hash file?

2062

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

2410

What are the different options associated with dsjob command?

1486

What is the difference between an operational datastage and a data warehouse?

1212

Why do we use exception activity in Datastage?

1373

Difference between server jobs & parallel jobs?

1134

How to Remove Duplicate using SQL?

1425

Can you explain engine tier in information server?

1189

Describe link sort?

1060

What are the functionalities of link partitioner?

1068

Define project in datastage?

1150

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

1113

Nls stands for what in datastage?

1238