Answer Detail: RE: Suppose session is configured with commit interval...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.

December 12, 2005 00:49:40	#1
suresh gorantla	Member Since: Visitor Total Comments: N/A
RE: Suppose session is configured with commit interval...
Source based commit will commit the data into target based on commit interval.so,for every 10,000 rows it will commit into target. Target based commit will commit the data into target based on buffer size of the target.i.e., it commits the data into target when ever the buffer fills.Let us assume that the buffer size is 6,000.So,for every 6,000 rows it commits the data.

Back To Question