Change data capture-comparison of 2 records in after dataset
Posted: Tue Dec 17, 2013 6:46 pm
Hi,
I have a job comparing 2 datasets - before and after and supposed to capture the edits and inserts.
The after dataset has 2 records with same key column and the before dataset has 1 record with the key column.
Before ds:
K1,1,a
After ds:
K1,1,a
K1,2,b
Expected Result;
K1,1,a,no change
K1,2,b,edit
Actual result:
K1,1,a,no change
K1,2,b,insert
When the job runs, the 1st record in After ds gets compared with the one in Before ds and outputs nothing as there is no change.
But the 2nd record in the After ds comes out as an insert even though the key matches with the one in Before ds, just because the Before ds record is exhausted.
Is there a work around, so that both After records gets compared with the one in Before dataset.
Thanks.
I have a job comparing 2 datasets - before and after and supposed to capture the edits and inserts.
The after dataset has 2 records with same key column and the before dataset has 1 record with the key column.
Before ds:
K1,1,a
After ds:
K1,1,a
K1,2,b
Expected Result;
K1,1,a,no change
K1,2,b,edit
Actual result:
K1,1,a,no change
K1,2,b,insert
When the job runs, the 1st record in After ds gets compared with the one in Before ds and outputs nothing as there is no change.
But the 2nd record in the After ds comes out as an insert even though the key matches with the one in Before ds, just because the Before ds record is exhausted.
Is there a work around, so that both After records gets compared with the one in Before dataset.
Thanks.