While doing Insert and Update on Target table, Update Strategy is poor in performance. Without using update strategy, how do you perform Insert and Updates? How do you design the mapping?
We can create two mappings. One for inserting the new records and, another one is for updating the existing record,
In the Update mapping, we have to connect the key column and columns which have to get updated of the target table. In the session only update the target rows have to check.
We can create two mappings. One for inserting the new records and, another one is for updating the existing record,
In the Update mapping, we have to connect the key column and columns which have to get updated of the target table. In the session only update the target rows have to check.
