What’s the difference between INSERT, UPDATE, UPSERT and DELETE actions available for data loading in a Database Table destination?

Using the INSERT, UPDATE and UPSERT options, you can add individual mapping ports for respective actions, which means Centerprise will create one mapping port for each action inside the Database Table Destination object.

The INSERT option pushes the incoming records to the destination.

The UPDATE option keeps track of the records being updated in the database table.

The UPSERT option is the combination of ‘Update’ and ‘Insert’ which means that it will check for the records that are inserted or updated.