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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in oracle target stage when we use load option and when we use upsert option?

2203


What is the method of removing duplicates, without the remove duplicate stage?

959


What are the types of hashed files in data stage

1057


What is datastage?

1029


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

2324


What are transforms and what is the differenece between routines and transforms?

998


how can we create rank using datastage?what is the meaning of rank?

8705


What is orabulk stage?

991


What is the difference between in process and inter process?

1090


Can you define merge?

1062


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

1236


What are some different alternative commands associated with "dsjob"?

1080


How to find value from a column in a dataset?

2147


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2226


What can we do with datastage director?

1164