how can find maximum salary by using Remove duplicate stage?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the main features of datastage?

654


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076


What are the types of containers?

685


what is use of SDR function?

4706


What all the types of jobs you developed?

665






Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3376


What is size of a transaction and an array means in a datastage?

737


project Steps,hits, Project level HArd things,Solved methods?

1623


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1627


Differentiate between odbc and drs stage?

593


What is a folder? Difference types of stages?

626


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1757


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2075


Give an idea of system variables.

587