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

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

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.

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'.

Answer / anitha

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

In one project how many shared containers are created?

3 Answers   NTT Data,

How to read the length of word in unix?

0 Answers   CTS,

What are the functionalities of link collector?

0 Answers  

where we use column generator stage in real time scenario?

5 Answers   TCS,

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

How can you join flat file, oracle as a sources?

4 Answers   IBM,

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

How do u view log file for a particular job?

6 Answers   HP,

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

0 Answers   IBM,

what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,

What is the process of killing a job in datastage?

0 Answers  

What is the default execution order of the sequential file?

3 Answers