How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 40275 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
What is resilience time?
How to improve the performance of a session using sorter transformation?
What is the fact table?
EXL informatica Questions
What is target load order?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
how to create user defined function (udf) in informatica
How to update a particular record in target with out running whole workflow?
How can we handle two sessions in informatica?
What will be the approach?
is it possible to index the data in cache of lkp transformation ?
What do mean by local and global repository?
Is stop and abort are same in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what is the difference between informatica6.1 and infomatica7.1
