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
- 28290 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 steps should be taken to improve Datastage jobs?
describe the Steps to confiure a Qlogic switch
Describe routines in datastage? Enlist various types of routines.
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
client know skid info?
Define ds designer?
What is the differentiate between data file and descriptor file?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the use of datastage designer?
What are system variables and sequencers in datastage
how to write server Routine coding?
Can you explain players in datastage?
How a server job can be converted to a parallel job?
Can you filter data in hashed file?
Name the command line functions to import and export the DS jobs?
