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.
Change capture: Duplicate records based on key
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Tue Jun 19, 2012 11:03 pm
- Location: India
-
- Premium Member
- Posts: 38
- Joined: Tue Jun 19, 2012 11:03 pm
- Location: India
I'm unclear why you think it wouldn't work, you should be fine. Do you have access to the documentation for the stage?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers