Every session has a PROPERTY of COMMIT interval. Commit interval is a point after which a session creates a log and commits the transaction at source, target or both LEVELS. For each commit interval it generates an id corresponding for each row and when a session is recovered it reads the LAST id inserted to target and then proceeds the loading from next row.

Eg: Source is having 1000 rows and commit interval is SET to 50 so it will commit for each 50 rows. Now session fails at row no 630. Now the target rows will be committed till 600th row as commit interval is 50. Once we recover a session the loading will start from 601th row.

Every session has a property of commit interval. Commit interval is a point after which a session creates a log and commits the transaction at source, target or both levels. For each commit interval it generates an id corresponding for each row and when a session is recovered it reads the last id inserted to target and then proceeds the loading from next row.

Eg: Source is having 1000 rows and commit interval is set to 50 so it will commit for each 50 rows. Now session fails at row no 630. Now the target rows will be committed till 600th row as commit interval is 50. Once we recover a session the loading will start from 601th row.