how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 13658 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 the types of hashed files in data stage
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the difference types of stages?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is use of SDR function?
What is ibm datastage?
Define oconv () and iconv () functions in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between the local container and shared container?
Define data aggregation?
What are the some differences between 7.x and 8.x version of datastage?
What is ibm datastage flow designer?
What is meta stage?
What is the difference between hashfile and sequential file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
