DSXchange

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

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

Yes,

The source records are updating.

Please help some one

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.

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