Change_Capture_Issue

Gopinath · Post by **Gopinath** » Fri Sep 26, 2008 12:57 pm

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.

jpram · Post by **jpram** » Mon Sep 29, 2008 6:07 am

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

Gopinath · Post by **Gopinath** » Mon Sep 29, 2008 10:39 pm

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.