Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 28567 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
What is the difference between server job and parallel jobs?
What is the use of datastage designer?
What is the difference between datastage and datastage tx?
What is orabulk stage?
Why do we use link partitioner and link collector in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How many types of hash files are there?
how to abort the job its matain duplicates?
what is the difference between == and eq in UNIX shell scripting?
How to Remove Duplicate using SQL?
Describe routines in datastage? Enlist various types of routines.
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
