Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44568 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / rakhee
No need to use any transformation.
Double click on SQ emp
go to property
click on SQL query
browse it
write query
SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
EMP
WHERE
ROWNUM<=10
ORDER BY SAL DESC
validate it
OK
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is rank transformation?
Explain in detail scd type 2 through mapping.
what is the difference between informatica6.1 and infomatica7.1
What is the difference between informatics 7x and 8x and what is latest version?
What is a mapplet/worklet in informatica?
What are some examples of informatica etl programs?
What are the different types of repositories created using informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to improve the performance of a session using sorter transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain lookup transformation in informatica
How can one identify whether mapping is correct or not without connecting session?
How to create the source and target database connections in server manager?
How to create a non-reusable instance of reusable transformations?
