UPSERT and INSERT Feature in Data Loader

UPSERT

This feature will update the row in the target table if a matching row exist otherwise if the matching row does not exist it will insert a new row.

Below is an example showing Source and Target table and the result you will get if you choose UPSERT loading option and comparing column as "ORDER_ID"

INSERT

This feature will insert a row in the target table only if the matching row does not exist

Below is an example showing Source and Target table and the result you will get if you choose INSERT loading option and comparing column as "ORDER_ID"