Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Michael_Litz
Support
Support

Hi Puja,

One reason you may be seeing a difference in the counts between a source and target table can have to do with a large source transaction with target latency.

I have seen where a task has 20 minutes of latency and the task is processing tens of thousands changes for a table. If a record count were to be done at this time the counts would be different because not all changes (Insert's) from the source have made it to the target. 

Once the task did catch up to near zero latency the counts were in sync. 

Please let me know if this helps.

Thank you,
Michael Litz
Technical Support Engineer