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
can you please explain me pre session and post session options?
Explain the informatica workflow?
where to store informatica rejected data?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
On which transformations you created partitions in your project?
Could you explain what is enterprise data warehouse?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the different types of repositories created using informatica?
Explain the difference between mapping parameter and mapping variable?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can we remove the duplicates from flat file source?
Explain about Informatica server process that how it works relates to mapping variables?
What is main use of mapplet?