how can find maximum salary by using Remove duplicate stage?
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
Explain the importance of surrogate key in data warehousing?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Define Job control?
What are the various kinds of the hash file?
What is ibm datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the different type of jobs in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Highlight the main features of datastage?
How do you register plug-ins?
What is the difference between an operational datastage and a data warehouse?
What is staging variable?
Explain how a source file is populated?
How the ipc stage work?