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
- 25295 Views
- Cognizant, HCL, TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / indu
Input->Sort1->Sort2->Trnsformer->Output
Sort1-->Declare class_id and Marks as key column and sort
in descding order.
Sort2-->Declare class_id and Marks as key column(Sort Mode
to Dont sort previously sorted for both) and set clustered
key change column to true.
Otuput for Sort 2 will be
class_id Marks Rank
102 90 1
102 35 0
101 60 1
101 50 0
101 40 0
In the Transformer declare stage variable temp and
initialize to o
Derive temp--> If Rnak=1 then Rank else temp+1
Derive output columns as --->
class_id ---> class_id
Marks ----> Marks
Rank----> temp
| Is This Answer Correct ? | 13 Yes | 10 No |
Post New Answer View All Answers
Is the value of staging variable stored temporarily or permanently?
What are the steps needed to create a simple basic datastage job?
What is a ds designer?
What are the types of containers?
What are routines in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Can you explain players in datastage?
How do you reject records in a transformer?
project Steps,hits, Project level HArd things,Solved methods?
What are the functionalities of link partitioner?
Which warehouse using in your datawarehouse
client know skid info?
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?
What can we do with datastage director?
What is the precedence of stage variables,derivations, and constraints?
