What is the difference in behavior between a database diff processor and a database table destination with the upsert box checked? They both handle update and insert but not delete. The two behaviors seem to be similar.
You’re right, there is no difference in both. The Database Diff Processor has been retained to ensure backward compatibility for users who have been using it. You can find this in Astera’s documentation as well.
Here’s the link to the help document: