Append with removing rows of data
I am wondering if there is way to setup the following scenario. I have an append that runs in the morning and all the new data gets added properly, however, there are situations where some of the source data is no longer needed for example if I started with 110 rows of data yesterday and throughout the day 10 were removed, then I only need 100 rows of data now. But what would happen if I also had some new rows in the source as well... for example 5 new rows, then my total show be 105
I attached a little chart for better visibility
I know a full replace will take care of this, but we are trying to minimize our row processing budget. Any solution for this or just simply the replace IS the only solution.?