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

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

Answers were Sorted based on User's Feedback



How to get max salary of an organization using data stage stages........... can any body help me..

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

How to get max salary of an organization using data stage stages........... can any body help me..

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

How to get max salary of an organization using data stage stages........... can any body help me..

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

How to get max salary of an organization using data stage stages........... can any body help me..

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

How to get max salary of an organization using data stage stages........... can any body help me..

Answer / sagnik

You need to sort by your SAL not COMPANY.

Is This Answer Correct ?    1 Yes 0 No

How to get max salary of an organization using data stage stages........... can any body help me..

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

How to get max salary of an organization using data stage stages........... can any body help me..

Answer / guest

U can use Aggregator stage in Datastage

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Data Stage Interview Questions

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

0 Answers   Cognizant,


Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  


what is time dimension? and how to populate time demension

2 Answers   TCS,


How many input links can you give to a Transformer stage?

6 Answers  






Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  


What is Cleanup Resources and when do you use it?

2 Answers  


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


What is size of a transaction and an array means in a datastage?

0 Answers  


how many stages are there in Datastage... Please clarify mee??

3 Answers  


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


Categories