We have a scenario where a change table missed some records a couple of weeks back. Fortunately, we have the option to resume from a timestamp in order to recover those records. The issue with this is that the changes are going to be replayed thus causing duplicates in the change table. (This is a change table only task btw)
In order to identify duplicates in the change table, is there a recommended way to do so? So far in my testing, I've identified the column header__stream_position, which looks like it should be unique for each change in the table. Can I use that to identify duplicates?
Help with this is greatly appreciated as always. Thank you.
