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?

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

whom do you report?

1484


Can you explain tagbatch restructure operator?

673


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2292


Can we use target hash file as a lookup ?

2789


How rejected rows are managed in datastage?

885






tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2677


What is the difference between validated and compiled in the datastage?

672


What are the components of ascential data stage?

626


Differentiate between data file and descriptor file?

593


CHANGE CAPTURE

861


What are the types of jobs we have in datastage?

651


What are the types of containers in datastage?

682


client know skid info?

1610


What steps should be taken to improve Datastage jobs?

613


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1605