How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / amjad
Hi Naga,
If we use Aggregator stage, it will give the max value from
different groups, as per your example, it will group by
company, then it will give the max sal from each group. but
how to max sal from all the groups, i mean the out put
should be only one value.
Ex:
COMPANY,SAL
A, 2000
B, 3000
C, 4000
A,5000
B,6000
C,7000
A,8000
B,9000
C,9999
if we do like you mention output will be like :
comp,maxsal
A,8000
B,9000
C,9999
But, the output should be only
C,9999
Plese let me if iam wrong.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and datastage tx?
What are datastage sequences?
Describe stream connector?
Define repository tables in datastage?
What is the difference between datastage and informatica?
Can you explain engine tier in information server?
What are the different plug-ins stages used in your projects?
What is size of a transaction and an array means in a datastage?
What are the stages in datastage?
Can you highlight the main features of ibm infosphere information server?
Explain connectivity between datastage with datasources?
What is a folder? Difference types of stages?
How to convert RGB Value to Hexadecimal values in datastage?
How to find value from a column in a dataset?
Can you explain link buffering?