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 we override a native sql query within informatica?
How to generate sequence numbers?
What is an Integration service in Informatica?
What is a pre-defined event and user-defined event?
Write the prerequisite tasks to achieve the session partition?
What are the prerequisite tasks to achieve the session partition?
What do you mean by worklet?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What does update strategy mean, and what are the different option of it?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
my source is junk data how will u remove that junk data by using unix please any one replay me
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Can we create two repositories on same database instance in oracle?
What is the difference between informatics 7x and 8x and what is latest version?
What are the components of workflow manager?