We are using dataset as a destination in dataflows for updating the DB tables. We have enabled "Insert new and overwrite existing records" save operation in destination dataset. We analyzed that for some records, the destination dataset is performing "Insert" operation. Because of this "Insert" operation taking place, we are getting exception (Error : duplicate key value violates unique constraint) since already that data exists in the table.
We are expecting only "Update" operation to be performed in this scenarios. But we are not sure why insert operation is performed at backend. Please help us to understand in which scenarios "Insert" operation is used & in which scenario "Update" operation is used?
Thanks in advance..
***Edited by Moderator Marissa to change type from General to Product, update Product details and Platform Capability tags****