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

how to create user defined function (udf) in informatica

1315


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1062


How to load a Dimension ? and how to load a fact table?

1423


Which files are created during the session rums by informatics server?

1186


What are pre and post-session shell commands?

1321


What is workflow? What are the components of workflow manager?

1180


design of staging area?

2031


What are the components of Informatica? And what is the purpose of each?

1060


What is difference between a gateway node and worker node?

1146


What is meant by active and passive transformation?

1131


What is informatica metadata and where is it stored?

995


What is the cumulative sum and moving sum?

1187


What are the designer tools for creating transformations?

1122


can we override a native sql query within informatica? How do we do it?

1132


What is dynamic cache?

1041