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
whom do you report?
Can you explain tagbatch restructure operator?
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)
Can we use target hash file as a lookup ?
How rejected rows are managed in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the difference between validated and compiled in the datastage?
What are the components of ascential data stage?
Differentiate between data file and descriptor file?
CHANGE CAPTURE
What are the types of jobs we have in datastage?
What are the types of containers in datastage?
client know skid info?
What steps should be taken to improve Datastage jobs?
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