As i understood only in case of Full SYNC which first deletes the old data and then insert new data one can have consistent view between source system and destination.
Is there any other way than this , which works with INCREMENTAL MODE.
Airbyte Incremental won’t capture soft deletes ONLY if you use CDC (which is a mode available for a database sources)
See docs about sync mode: https://docs.airbyte.com/understanding-airbyte/connections/
See doc here about CDC: https://docs.airbyte.com/understanding-airbyte/cdc
Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.