how can find maximum salary by using Remove duplicate stage?
Answer Posted / phani kumar
By using Sort stage, sort the data in Descending order, then
use remove duplicates stage, set option as first occurrence
of records. Then we will get max sal record first.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the important features of datastage?
What is the difference between passive stage and active stage?
What is the difference between the local container and shared container?
Is the value of staging variable stored temporarily or permanently?
How to convert RGB Value to Hexadecimal values in datastage?
How to perform incremental load in datastage?
How to reverse the string using SQL?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the different type of jobs in datastage?
how to export or import the jobs in .ISX file
What is merge stage?
Describe the main features of datastage?
Highlight the main features of datastage?
How you can fix the truncated data error in datastage?
what are the errors,warnings in datastage