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
- 25486 Views
- Cognizant, HCL, TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / amulya kumar panda
you are use
transformer if (Marks > 50 or 40 <Marks ) then rank=2 else
if Marks > 60 then rank=1 else rank=4
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What are the main features of datastage?
how many rows sorted in sort stage by default in server jobs
how to implement scd2 in datastage 7.5 with lookup stage
EXPLAIN SCD
How to convert RGB Value to Hexadecimal values in datastage?
Define APT_CONFIG in Datastage?
What are the different kinds of views available in a datastage director?
What is a merge?
What are the various kinds of the hash file?
What is a ds designer?
What are the functionalities of link collector?
How to manage date conversion in Datastage?
What is the flow of loading data into fact & dimensional tables?
Differentiate between hash file and sequential file?
What is the precedence of stage variables,derivations, and constraints?
