difference between source based commit? and target based
commit? which is better with respect to performance?
- 6 Answers
- 17606 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / siva
If you set the source based commit, say 1000, it executes
commit after immediate of 1000 records read, irrespective
of how many rows passed to target (may be 600 since 400
dropped).
Similarly, if you set target based commit, say 1000, it
executes commit after immediate of 1000 records inserted,
irrespective of records read from source (may be 1500, rest
of 500 dropped)..
I think you got it..
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a grid in Informatica?
Explain scd type 3 through mapping.
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is an active transformation?
How you can differentiate between connected lookup and unconnected lookup?
How might one distinguish in the case of mapping is right or not without associating session?
What are the new features of Power Center 5.0?
Difference between Target-based loading and constraint-based loading?
what is INFORMATICA TESTING process
Why filter transformation is an active one?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is informatica metadata and where is it stored?
