how can find maximum salary by using Remove duplicate stage?

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Question Posted / bkarthikmca

5 Answers
13774 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can find maximum salary by using Remove duplicate stage?..

Answer / 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

how can find maximum salary by using Remove duplicate stage?..

Answer / narayana.3ds

R.D Stage remove the duplicates every one knows but u can
find max salary......
Give the key of salary order by descending other
option u can put=first

Is This Answer Correct ?

5 Yes

2 No

how can find maximum salary by using Remove duplicate stage?..

Answer / phani kumar

By using Sort stage, sort the data in Descending order, then
use remove duplicates stage, set option as first occurrence
of records. Then we will get max sal record first.

Is This Answer Correct ?

2 Yes

1 No

how can find maximum salary by using Remove duplicate stage?..

Answer / akila

In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.

Is This Answer Correct ?

0 Yes

0 No

how can find maximum salary by using Remove duplicate stage?..

Answer / anitha

https://www.docstoc.com/pro/2134166

Is This Answer Correct ?

1 Yes

4 No

Post New Answer