What is source based commit and target based commit with an example ? What is the background process that wil be done if you select source based commit or target based commit ?

Interview Candidate
Apr 8th, 2007
1
7675

Showing Answers 1 - 1 of 1 Answers

J.David Sukeerthi Kumar

May 17th, 2007

There is on option called 'COMMIT INTERVAL', (By default its value is 10000 records)
That means for every 10000 records loaded ,the informatica server will issue an COMMIT command.

If we specify 'SOURCE BASED COMMIT', Then for every 10000 records extracted from source, (no matter whether all 10000 reocrds loaded into DWH or not) Informatica server issues an COMMIT command.

If we specify "TARGET BASED COMMIT', even though 10000 records are loaded into DWH, the Informatica server does not issues an COMMIT command until the default buffer size reaches. Once reached, that data will be loaded (more than 10000 records)