Rows per commit
Posted: Mon Oct 06, 2008 5:50 am
Hi
Commit frequency in Job properties is related to the number of rows it processes. Meaning, if the values is 100, it will commit after 100th record is loaded successfully on the target table.
This should be true for one output link to one target. What happens if the input is one and output links are multiple? Here, one input row is split into multiple rows, may be from a transformer going into different tables. Now, how are the rows counted for commit to happen? Is it counted at source or at output? Assuming the counting is at the output, does it take output links into consideration where one input row is split into multiple rows?
I hope the explanation is understandable.
Regards
Rupesh
Commit frequency in Job properties is related to the number of rows it processes. Meaning, if the values is 100, it will commit after 100th record is loaded successfully on the target table.
This should be true for one output link to one target. What happens if the input is one and output links are multiple? Here, one input row is split into multiple rows, may be from a transformer going into different tables. Now, how are the rows counted for commit to happen? Is it counted at source or at output? Assuming the counting is at the output, does it take output links into consideration where one input row is split into multiple rows?
I hope the explanation is understandable.
Regards
Rupesh