How to properly replace data when using Upsert for Output?
Hello, I am currently testing out Upsert for the Update Method of the output dataset and I am confused about how it functions. From what I understand, it serves as both an append and replace update method where you can append on the current data to the historical data that exists. The issue I am facing is that I wanted to…