Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.......

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


Please Help Members By Posting Answers For Below Questions

sed,awk,head

1501


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2414


what is repositery?

1928


How and where you used hash file?

1222


Could anyone give brief explanation bout datastage admin

2406


On which interface you will be working as a developer?

1106


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1096


Demonstrate experience in maintaining quality process standards?

2638


What are the components of datastage?

1179


Differentiate between validated and Compiled in the Datastage?

1355


Have you have ever worked in unix environment and why it is useful in datastage?

1182


How do u convert the columns to rows in datastage?

1245


To see hidden files in LINIX?

1589


Why do you need stage variables?

1229


Where do the datastage jobs get stored?

1268