A commit interval is the interval at which power center server
commits data to targets during a session. The commit interval the number of
rows you want to use as a basis for the commit point.
Target Based commit: The power center server commits data based on
the number of target rows and the key constraints on the target table. The
commit point also depends on the buffer block size and the commit interval.
Source-based commit:---------------------------------------------
User-defined commit:----------------------------------------------
No comments:
Post a Comment