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
- 25382 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 are orabulk and bcp stages?
What are the types of hashed files in data stage
What are the processing stages?
how to delete one row in target dataset
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the method of removing duplicates, without the remove duplicate stage?
How to RD using transformer?
What is the difference between account and directory options ?
Is possible to create skid in dim,fact tables?
What is use Array size in datastage
Can we use target hash file as a lookup ?
Can you define merge?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
project Steps,hits, Project level HArd things,Solved methods?
Explain ibm infosphere information server and highlight its main features?
