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
Differentiate between sessions and batches?
Make a note of the quantity vaults made in informatica?
What is an expression transformation?
Explain the aggregator transformation?
What is dimensional table?
While migrating the data from one environment to another environment how would you manage the connections?
What are the different versions of informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to use pmcmd utility command?
How to implement security measures using repository manager?
What do mean by local and global repository?
What is a dimensional model?
Explain what transformation and how many are there in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.