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 list Top 10 salary, without using Rank Transmission?

Answer Posted / abhilash

do following steps

1.in source qualifier override the query with
"order by salary desc"

2. use seq gen tr on it and give column name as "sid"

3. next use filter tr. in that write condition like "sid<=10"

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different versions of informatica?

1037


Which are the different editions of informatica powercenter that are available?

971


how we can load rejected record's at run time?(not through bad files)

2315


How to generate sequence numbers without using the sequence generator transformation?

1115


Explain sessions?

986


What is rank transform?

944


Can we change Dynamic to Static or Persistent cache? If so what happens?

2152


State the differences between sql override and lookup override?

1114


What is dimensional table? Explain the different dimensions.

1113


What is data caches/ index caches?

1024


Define pmcmd command?

994


What are mapplets?

1213


How can you generate reports in informatica?

973


how tokens will generate?

2156


What is resilience time?

1051