DSXchange

Hi Friends,

Iam using a ChangeCapture stage, volume is 40k.

For manual verification, i have modified one new insert record and one update record, when i tried using a Dataset after changecapture stage iam getting the changecode as "2" for both Insert n Update.

My Understanding is,
ChangeCode
Insert 1
Delete 2
Update 3

But how CC stage is giving changecode as "2". And that too, if i run the job repeatedly with one time modification in the target table, then iam getting different in counts.

Any Important properties or default setting is there for these kind of issues..
Can anyone help me on this..
Thanks.

Check the options you have used like,Explicit Key all columns,etc....
If you have key columns specified seperately

jpram wrote:Check the options you have used like,Explicit Key all columns,etc....
If you have key columns specified seperately

Hi,

Thanks for ur reply. I have used the option "Explicit Keys & All values".
I got the solution, the problem is in the source extract.
Thanks.