https://community.qlik.com/t5/Qlik-Replicate/Checking-CDC-target-for-gaps/m-p/1822418#M978 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.<BR /> Thu, 15 Jul 2021 13:47:07 GMT PGN 2021-07-15T13:47:07Z https://community.qlik.com/t5/Qlik-Replicate/Checking-CDC-target-for-gaps/m-p/1822411#M977 <P>Looking for recommendations for an approach to do an end of day check for 'gaps' in the target table (missing changes).</P><P>&nbsp;</P> Thu, 15 Jul 2021 13:36:34 GMT https://community.qlik.com/t5/Qlik-Replicate/Checking-CDC-target-for-gaps/m-p/1822411#M977 DavidFoster1 2021-07-15T13:36:34Z https://community.qlik.com/t5/Qlik-Replicate/Checking-CDC-target-for-gaps/m-p/1822418#M978 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.<BR /> Thu, 15 Jul 2021 13:47:07 GMT https://community.qlik.com/t5/Qlik-Replicate/Checking-CDC-target-for-gaps/m-p/1822418#M978 PGN 2021-07-15T13:47:07Z