Change capture giving difference between 8.5 and 9.1 count

deesh · Post by **deesh** » Thu Apr 10, 2014 9:45 am

Hi,

When i run the 8.5 version same job and tables in 9.1 using with Change capture, it is giving different record count in 9.1

pls find below stats

8.5

CreateDelta,0: Statistics:
Before records : 25749
After records : 25970
Output records : 6418
Insert records : 707
Delete records : 486
Edit records : 5225
Copy records : 20038.

9.1

CreateDelta,0: Statistics:
Before records : 25749
After records : 25970
Output records : 6251
Insert records : 707
Delete records : 486
Edit records : 5058
Copy records : 20205. but both the version job and stage properties are same

qt_ky · Post by **qt_ky** » Thu Apr 10, 2014 2:35 pm

Is it possible that 167 records were updated in the source table between the two job runs?

deesh · Post by **deesh** » Thu Apr 10, 2014 8:56 pm

Yes,

The source records are updating.

Please help some one

chulett · Post by **chulett** » Sun Apr 13, 2014 11:48 pm

Not sure what kind of help you need. Did you understand that when you said "the source records are updating" you are basically telling us you have no problem? Perhaps you did not understand the question - he was asking if between the 8.5 and 9.1 job runs more updates had been done and you said "yes"... which would explain the difference in counts.

If that's not the case, please clarify your situation for us.

deesh · Post by **deesh** » Wed Apr 16, 2014 6:50 am

Working fine After I have done the linksort for before and after data links in chagecapture.