how can find maximum salary by using Remove duplicate stage?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2742


What is the difference between Datastage 7.5 and 7.0?

671


Have you used Unstructured data?

830


What is a folder? Difference types of stages?

626


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1801






what is flow of project?

1557


What are the components of datastage?

646


What are the different layers in the information server architecture?

641


How a server job can be converted to a parallel job?

619


sed,awk,head

966


Where do the datastage jobs get stored?

728


What is active and passive stage?

876


which r the connectors used in san?

1786


Describe routines in datastage? Enlist various types of routines.

579


Can you implement SCD2 using join, transformer and funnel stage?

1082