Wednesday, March 13, 2013

Commit Interval In Informatica

Commit interval means the interval at which Informatica server will commit or write into the Database.We can adjust the commit interval by clicking the Advanced Options button from session properties.If commit interval is less then it reduces the performance becasue Informatica server will have to commit the data frequently.When the commit interval is more informatica will get more time gap for commiting the data.This makes performance faster.
Also you do have to note that when you increase the performance of the workflow by increasing the commit interval you have the risk of loosing the data while recovery since most of the buffers will be holding the data to be commited.

No comments:

Post a Comment