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

What is the project in datastage?

673


What is a merge in datastage?

774


What is "fatal error/rdbms code 3996" error?

666


How to read multiple files using a single datastage job if files have the same metadata?

744


Explain the situation where you have applied SCD in your project?

1568






What are the steps needed to create a simple basic datastage job?

667


How do you schedule or monitoring the job?

676


How many areas for files does datastage have?

645


How do u convert the columns to rows in datastage?

694


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1672


What is the difference between in process and inter process?

679


What are the features of datastage flow designer?

639


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

1635


sed,awk,head

974


What is datastage?

652