Summary
User inquires about the behavior of incremental append with MSSQL as both source and destination, specifically regarding data updates not reflecting in the destination when using queries, and whether this is related to the absence of CDC (Change Data Capture) option.
Question
hi guys,
do you know if using incremental | append with source mssql and destination mssql, when using query update the data is not updated? only insert that change the data in destination.
is that because I’m not using cdc option?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.