How to get max salary of an organization using data stage
stages...........

can any body help me plz.......

Answer Posted / shar

ok lets us say after getting result like
a,8000
b,9000
c,9999
acc to nandhini using dummy key would give me
a,8000,1
b,9000,1
c,9999,1
then use rem duplicate stage then we get 9999 as output after we assign retain duplicates=last for dummykey col.
what if
i have diff data and got output like below after aggreagation
a,9000
b,18000
c,10000
now what...?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Routines and their types?

621


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

1669


Which algorithm you used for your hashfile?

691


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1619


Where do the datastage jobs get stored?

733






What is the flow of loading data into fact & dimensional tables?

598


What are some different alternative commands associated with "dsjob"?

657


What is a datastage job?

621


How to find value from a column in a dataset?

1769


What is a merge?

672


what is the use of surogate key in datastage

1823


What is the project in datastage?

668


What is meta stage?

579


Can you explain players in datastage?

708


How we can covert server job to a parallel job?

599