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
- 19297 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
What is Cognos script editor?
Define the various join types of joiner transformation?
Why update strategy and union transformations are active?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is the hint? how to use it to reduce the query processing in program?
What is a difference between complete, stop and abort?
What is the surrogate key?
What does update strategy mean, and what are the different option of it?
Explain load alternative records / rows into multiple targets - informatica
Which version configuration tool used in ur project?
What is a transaction control transformation?
How do you set a varible in incremental aggregation
Define enterprise data warehousing?
What is meant by pre and post session shell command?
my source is junk data how will u remove that junk data by using unix please any one replay me
