Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14941 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 is the difference between datastage and datastage tx?
Could anyone give brief explanation bout datastage admin
What is a merge?
What steps should be taken to improve Datastage jobs?
Describe routines in datastage? Enlist various types of routines.
Can you implement SCD2 using join, transformer and funnel stage?
What are iconv and oconv?
How a server job can be converted to a parallel job?
What are the job parameters?
Describe link sort?
Differentiate between operational datastage (ods) and data warehouse?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the different types of lookups in datastage?
what is flow of project?
