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

Use source Qualifier Transformation,we can edit the default
sql query and write like as
select * from ( select * from emp
order by sal desc)
where rownum <11;

Is This Answer Correct ?    29 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a non-reusable instance of reusable transformations?

1132


what is the hint? how to use it to reduce the query processing in program?

7835


What is dimensional table? Explain the different dimensions.

1172


Is there any target staging area in informatica not staging area

2578


Explain your project of banking domian.

1652


What is an expression transformation in informatica?

1038


How many input parameters can exist in an unconnected lookup?

1545


Why do we need informatica?

992


Which version configuration tool used in ur project?

3258


What is domain and gateway node?

1165


What is the surrogate key?

1261


What are Dimensional table?

1055


When do you use sql override in a lookup transformation?

1099


What is informatica powercenter repository?

1202


Explain the different lookup methods used in informatica?

1042