before link
KEY1,KEY2,Data1,Data2
After Link
KEY1,KEY2,Data1,Data2
KEY1,KEY2,Data3,Data4
as you can see there is duplicate key value in after link
I set up on job with Change capture with reject copy option.
but i got KEY1,KEY2,Data3,Data4 as new record and should be insert
and duplicate error when insert
do you know why?
Change Capture stage with duplicate after link
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Thu Dec 04, 2008 11:25 pm
From the guide: "The Change Capture stage takes two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set."
I think the first pair of records, the copy, did get rejected, and that action consumed them, then the stage moved on to compare the next record(s) available.
Double check to make sure that your before and after link ordering is correct or if it needs to be swapped.
I think the first pair of records, the copy, did get rejected, and that action consumed them, then the stage moved on to compare the next record(s) available.
Double check to make sure that your before and after link ordering is correct or if it needs to be swapped.
Choose a job you love, and you will never have to work a day in your life. - Confucius