Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12655 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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
can we override a native sql query within informatica? Where do we do it?
Define Pmrep command?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the differences between source qualifier and joiner transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How do you load unique records into one target table and duplicate records into a different target table?
While migrating the data from one environment to another environment how would you manage the connections?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the different types of repositories created using informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Sequence generator, when you move from develoment to production how will you reset
what are the deliverables?in your project?
