Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44083 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 the benefit of session partitioning?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is decode in informatica?
What are the types of lookup transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
State the limitations where we cannot use joiner in the mapping pipeline?
Is stop and abort are same in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explian the Process of deployment groups in informatica
How can we store previous session logs?
What is the difference between informatica 7.0 and 8.0?
Explain pmcmd command usage in informatica
What is the use of source qualifier?
What are active transformations.
