Change capture: Duplicate records based on key
Posted: Wed Oct 22, 2014 12:40 pm
Hi,
I have a before and after dataset which have two columns PK(Primary key) and VK(Value key). Now in the Before dataset I have records like:
PK VK
A 1
A 2
A 3
In the after dataset I have all the records in before dataset plus some new records like:
PK VK
A 1
A 2
A 3
A 4
A 5
B 1
Will my change capture be able to work properly considering that I have duplicate records in both before and after dataset. Also, if change capture does not work with duplicate records, does it mean duplicate records in after dataset or duplicate record in before dataset.
I have a before and after dataset which have two columns PK(Primary key) and VK(Value key). Now in the Before dataset I have records like:
PK VK
A 1
A 2
A 3
In the after dataset I have all the records in before dataset plus some new records like:
PK VK
A 1
A 2
A 3
A 4
A 5
B 1
Will my change capture be able to work properly considering that I have duplicate records in both before and after dataset. Also, if change capture does not work with duplicate records, does it mean duplicate records in after dataset or duplicate record in before dataset.