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 can you find the 2nd Highest salary in a file department wise in abinitio?

Answer Posted / raje0303

Hi Murali,

This logic is correct only will fail when highest salary entries are more than one (e.g. two people has highest and equal salary )
we need to updated scan function as below -

type temporary_type=record
integer(4) temp1;
integer(4) last_sal;
end;

temp :: initialize(in) =
begin
temp.temp1::0;
temp.last_sal::0;
end;



out :: scan(temp, in) =
begin
if(last_sal != in.salary)
begin
out.temp1 :: temp.temp1 + 1;
end;
last_sal = in.salay;
end

out :: finalize(temp, in) =
begin
out.sal:: in.sal;
out.dno :: in.dno;
out.temp1 :: temp.temp1;
end;
out :: output_select(out) =
begin
out::out.temp1 == 2;
end;
###############################################
4.Output_file

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can a graph be run infinitely?

1067


What is the max core of a component?

1025


Give one reason when you need to consider multiple data processing?

1112


What are the factors on which storage of data depends?

1096


How can I run the 2 gui merge files?

1120


Mention what is the syntax for m_dump in abinitio?

1406


Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1069


State the working process of decimal_strip function?

2079


What do you mean by data sorting?

1118


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

1185


What do you mean by a transaction file and how it is different from that of a sort file?

1000


Explain data flow graph with an example?

1060


What is the purpose of having stored procedures in a data-based?

1008


how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2065


What is broadcasting and replicate?

1108