Interested to Buy Any Domain ? << Click Here >> for more details...
difference between source based commit? and target based
commit? which is better with respect to performance?
- 6 Answers
- 19085 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 to open an older version of an object in the workspace?
Enlist the tasks for which source qualifier transformation is used.
What is the meaning of up gradation of repository?
Explain the types of lookup transformation?
what is unit testing?tell me proceedure
What are the performance considerations when working with aggregator transformation?
expain about the tune parameters?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In development project what is the process to follow for an etl developer from day1
What is a mapplet/worklet in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Describe the impact of several join conditions and join order in a joiner transformation?
How many ways are there to do 'remove duplicate records in informatica'?
differences between service based and product based?
How are indexes created after completing the load process?
