Monday, March 18, 2013

What Commit Interval does?

In INFA the Commit Interval Property help Integration Service commits rows to targets based on the commit interval.
If the session fails for some reason then,the Integration Service rolls back to the last commit point, The roll back depends on the commit interval configured in the session.
In your case, set the Commit interval = 90, and verify it.
There are two Commit types in INFA
  • Target Commit Interval
  • Source Commit Interval.

No comments:

Post a Comment