How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / 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 |
Post New Answer View All Answers
How and where you used hash file?
Define Routines and their types?
Which algorithm you used for your hashfile?
How can one find bugs in job sequence?
Is possible to create skid in dim,fact tables?
What are the functionalities of link partitioner?
What could be a data source system?
What is the use of datastage director?
What are the types of containers in datastage?
Name the third party tools that can be used in datastage?
Name the different types of Lookups in Datastage?
how to export or import the jobs in .ISX file
How many types of sorting methods are available in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Define project in datastage?