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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

table actions available in oracle connector?

1605


Is possible to create skid in dim,fact tables?

2635


What is the difference between datastage and datastage tx?

1063


EXPLAIN SCD

1391


how to add a new records into source?

1996


What is job control?

1109


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2462


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1502


What is the flow of loading data into fact & dimensional tables?

1062


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

8787


What is datastage?

1081


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277


Why do we use exception activity in Datastage?

1308


How to reverse the string using unix?

3503


What is the purpose of interprocessor stage in server jobs?

2231