Hi ,
We have a Scenario where we have enabled the cdc on source sql server and we are receiving multiple transaction logs updates for the same combination of primary key and timestamp and some other values have changed apart from the primary key we are not able to identify the latest transaction since the timestamp is same in source Format HH:MM:SS.
Both the records are flowing into the topic and then into the downstream.
We checked for a __$seqval combination as well we have 2 records
Example
Column1|Column2|Column3|Column4|Non_PK_Column|TimeStampcolumn
ABC |CBD |EFG |HIJ |2000 | 11-04-2025 11:24:42
ABC |CBD |EFG |HIJ |4000 | 11-04-2025 11:24:42
It there any approach that we can use or any other connector that can be used to handle such scenarios