As a part of testing conducted in the lower environment, we observed that when a Salesforce field is removed from the source, the historical data for that field in the destination is updated to NULL.

We are seeking a solution to manage this situation without automatically updating or setting the deleted columns to NULL when they are removed from the source. Ideally, we would like to avoid this behavior. Any guidance or solution you can provide/implement would be greatly appreciated.

Here is the case to track this

https://support.fivetran.com/hc/en-us/requests/181398