Interested to Buy Any Domain ? << Click Here >> for more details...
How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
- 7 Answers
- 30455 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga
firstly read the file into database or sequential file and
make sure the file has company as a column in this file and
give its output to aggregator and in aggregator give
group=company and column to calculate=sal and maximum value
for output column=maxsal and do mapping to the dataset and
you will get the required result.
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / 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 |
Answer / guest
Frist using Sortstage sort the records based on sal column
for desc order and Each record unqiely identify using
surogatekey after that filterstage filter the first record
based on sur column and drag and drop only in sal column
in the output.Then We get the Max sal
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nandhini
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
which unix commands mostly used in datastage
What is meta stage?
What is the process of killing a job in datastage?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Why fact table is in normal form?
What are the partitioning techniques available in link partitioner?
what is the diff between sequential file and fileset stages?
What are the features of datastage flow designer?
How can you join flat file, oracle as a sources?
how to identifie,is it innerjoin,leftouter join in lookup?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
Enlist various types of routines in datastage.
Teradata 
