how to get the first row without using rank t/r?
Answer Posted / moorthy g
In Source Qualifier Sql Override
Ex: Table Name: Dept1
SELECT DEPT1.DEPTNO, DEPT1.DNAME, DEPT1.LOC
FROM
DEPT1
WHERE ROWNUM=1
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
According to his methodology what all you need before you build a datawarehouse
Please let me know how to make Data masking in informatica..
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain the pipeline partition with real time example?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
is it possible to index the data in cache of lkp transformation ?
How do you convert single row from source into three rows into target?
Describe the impact of several join conditions and join order in a joiner transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the various types of transformation?
How to load the data from people soft hrm to people soft erm using informatica?
What is rank transformation?
Explain direct and indirect flat file loading (source file type) - informatica
Where can we find the throughput option in informatica?