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.
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