Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
DavidFoster1
Specialist
Specialist

Checking CDC target for gaps

Looking for recommendations for an approach to do an end of day check for 'gaps' in the target table (missing changes).

 

Labels (1)
1 Reply
PGN
Contributor III
Contributor III

We do a daily tablediff (MS utility) to check for differences between source and target). However, if your environment uses _CDC tables, that utility will only identify the differences and provide SQL statements to update, not the _CDC table entries.