Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14680 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
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the differences between datastage and informatica?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What a datastage macro?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the different type of jobs in datastage?
Differentiate between odbc and drs stage?
What is the difference between odbc and drs stage?
Define project in datastage?
Explain how a source file is populated?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is active and passive stage?
Why do you need stage variables?
what is ds administrator used for?
What are the enhancements made in datastage 7.5 compare with 7.0?
