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

What is the way to execute pl/sql script using informatica mapping?

1083


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1621


What are the new features of informatica 9.x at the developer level?

702


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

700






Explain about Informatica server process that how it works relates to mapping variables?

714


What is Session and Batches?

773


Briefly define reusable transformation?

725


How do you remove duplicate records in informatica? And how many ways are there to do it?

808


How can we use mapping variables in informatica? Where do we use them?

731


What is the function of aggregator transformation?

667


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1764


what are factless facts? And in which scenario will you use such kinds of fact tables.

1413


What is informatica?

771


What are the advantages of informatica?

662