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
- 28676 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
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
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Describe link sort?
What are the types of containers?
Enlist various types of routines in datastage.
how can we create rank using datastage?what is the meaning of rank?
What are the various kinds of the hash file?
How to read the length of word in unix?
What are datastage sequences?
Difference between sequential file and data set?
Difference between in process and inter process?
Which commands are used to import and export the datastage jobs?
What is the importance of the exception activity in datastage?
How to Remove Duplicate using SQL?
how to implement scd2 in datastage 7.5 with lookup stage
