The Commit Change Filter component allows you to commit, rollback or reset (clear) changes to a specified Delta database.  For more information on Delta databases please consult the Change Filter Component. You should commit a Delta database when you want the most recent data sent to the database to be committed as a synchronization point, such that it is the defining point of refernece going forwards.  Note that the Change Filter Component can be configured to automatically commit.

Rollback is not strictly necessary as it is implicit if a session is not explicitly committed.

Reset can be useful to clear out records relating to a specific Batch Id, for example before using two Change Filter Components to compare a table or view.  If you reset a Delta database then all subsequent records will be determined as new records until the next commit, this avoiding the need for a union and also increasing efficiency.

To configure a Commit Change Filter component, drag one onto the data-flow surface and connect it in to any predecessor components. Then double-click to configure.



Then simply select the Delta database connection and the Batch Id, as used by the associated Change Filter Component/s.