Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14721 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
For RMD Stage we need Grouping Keys, Add one extra hard coded Column to each Input records in previous stage.
DUMMY=1
In RMD Stage,
HASH partition on DUMMY, Sort DESC on Salary
and select DUMMY as Key in properties tab.
"Duplicate to Retain"=First.
then you will get only Highest Salart only from RMD Stage
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are constraints and derivations?
table actions available in oracle connector?
What are the different kinds of views available in a datastage director?
What is aggtorec restructure operator?
client know skid info?
how to abort the job its matain duplicates?
Describe stream connector?
What are the components of ascential data stage?
Differentiate between datastage and datastage tx?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is repositery?
What is the difference between in process and inter process?
On which Dimension Table you implemented SCD Type in your Project
how can we create rank using datastage?what is the meaning of rank?
How to perform incremental load in datastage?
