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
Describe the architecture of datastage?
What is ibm datastage?
What are the main features of datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what is the difference between == and eq in UNIX shell scripting?
What are the various kinds of the hash file?
Is it possible to query a hash file?
client know skid info?
AGGREGATOR default datatype
How many types of stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are orabulk and bcp stages?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you remove duplicate values in datastage?
Differentiate between hash file and sequential file?