How to list Top 10 salary, without using Rank Transmission?
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
Can informatica load heterogeneous targets from heterogeneous sources?
On which transformations you created partitions in your project?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
without table how to come first record only in oracle?
How identifying bottlenecks in various components of informatica and resolving them?
Write the unconnected lookup syntax?
difference between repository database and repository service?
Sequence generator, when you move from develoment to production how will you reset
Briefly explain the aggregator transformation?
scenario where i can use only concurrent execution of workflow.
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
How can you increase the performance in joiner transformation?
Mention a few design and development best practices for informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
generate date / time dimension in informatica