Mar 20, 2011

source based commit and Target based commit


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)

No comments:

Post a Comment