Answer Posted / saif
uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is a pre-defined event and user-defined event?
What are the different types of transformation available in informatica.
While migrating the data from one environment to another environment how would you manage the connections?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a filter transformation and why it is an active one?
What is transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How we can create indexes after completing the loan process?
Can we create multiple integration service on single repository?
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?
How to partition the Session?
What are the different ways to implement parallel processing in informatica?