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

In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / hardeep

We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we call shell scripts from informatica?

1083


difference between repository database and repository service?

1131


Differentiate between a repository server and a powerhouse?

1098


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4711


Reusable transformation and shortcut differences

1819


What does role playing dimension mean?

1031


How do you promote a non-reusable transformation to reusable transformation?

1114


What are the different clients of powercenter?

1040


What is the difference between a connected look up and unconnected lookup?

952


How can we improve session performance in aggregator transformation?

1089


What are pre and post-session shell commands?

1282


is it possible to index the data in cache of lkp transformation ?

2014


What is a joiner transformation and why it is an active one?

1057


What is source qualifier transformation in informatica?

987


What are the types of caches in lookup?

1034