MSSQL Source Connector Incorrectly using >= stored cursor value to identify change set, causing changes to be identified on multiple days #70945
Description
Connector Name
source-mssql
Connector Version
4.2.5
What step the error happened?
During the sync
Relevant information
Bulk Insert with Incremental append & Dedup is using >= Cursor Value to identify a relevant change set, this is resulting in the same change set being identified on consecutive days and Unnecessary network transfer and processing overhead, Increased sync duration and Destination deduplication overhead for records that shouldn't be re-read. It should just use > Cursor Value
Relevant log output
Contribute
- Yes, I want to contribute