There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Existing members in Dim Table are inserted again
Though similar issues are tracker here already, they doesn't completely map to my actual issues.
I have a quite small dimension table (<3000 rows), which is filled with the SCDC.
After it runs a few times without any problems, today it started to try to insert rows, which already exists in the Dim table.
I compared the surrogate and the business key. They are identical.
I compared all SCD2 Attributes. No changes between Source and existing dimension.
Because I have a unique index on the surrogate key, the load process stops now.
This affects only 9 rows of a total of 204 new rows. The others are "true" new rows.
It's really strange.
I hope there is a solution for this.