You can use the Incremental Load template when you want to identify and capture the data that has been added, changed, or deleted in a database table. The Incremental Load template can be used in the following ways:

For example, Karen works in a sales environment where the target database is updated at the end of each day to include the whole history of transactions. The database is updated by running a workflow. Karen uses the Incremental Load template to update the target database. This template ensures that only the changed data, and not the entire data, is loaded into the target database.