Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44565 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / chinthi
SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What is the difference between Active and Passive transformation?
Explain the difference between mapping parameter and mapping variable?
write a query to retrieve the latest records from the table sorted by version(scd)
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the components of Informatica? And what is the purpose of each?
list out all the transformations which use cache?
How identifying bottlenecks in various components of informatica and resolving them?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to call shell scripts from informatica?
What are the advantages of using informatica as an etl tool over teradata?
How do you load alternate records into different tables through mapping flow?
Describe expression transformation?
What is the Rank index port in Rank transformation?
What are connected or unconnected transformations?
