Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12458 Views
- iGate, I also Faced
- E-Mail Answers
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
What is rank transformation?
how to load dimension table and fact table. plz tell me the steps.
Can you use flat files in Mapplets.
Differences between connected and unconnected lookup?
How to open an older version of an object in the workspace?
What are mapplets? How is it different from a Reusable Transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to use pmcmd utility command?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are session parameters ? How do you set them?
How do you load only null records into target?
Explain incremental aggregation in informatica
what is index?how it can work in informatica
What are different types of transformations available in informatica?
What is meant by pre and post session shell command?
