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?
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
How to implement complex jobs in data stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is a merge in datastage?
What are system variables and sequencers in datastage
How to perform incremental load in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Give an idea of system variables.
What is difference between join, merge and lookup stage?
Describe the architecture of datastage?
How many areas for files does datastage have?
What is the command line function to import and export the ds jobs?
What is the different type of jobs in datastage?
how can we create rank using datastage?what is the meaning of rank?
Lookup constraints
What is the flow of loading data into fact & dimensional tables?