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
- 28695 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 is difference between join, merge and lookup stage?
What are the types of jobs we have in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how can we create rank using datastage?what is the meaning of rank?
Differentiate between hash file and sequential file?
To see hidden files in LINIX?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
If you want to use the same piece of code in different jobs, how will you achieve it?
how to add a new records into source?
What is active and passive stage?
What are stage variables and constants?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Explain the situation where you have applied SCD in your project?
what is use of SDR function?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
