How to refresh full compose tables without a drop and recreate

[Nanda_Ravindra]

The information in this article is provided as-is and to be used at your discretion. So, please implement and test this in your testing environment before applying this to production.

1. Stop the Qlik Replicate task that you want to reload all the tables.
2. On the Compose server:
   1. Run the CDC for the task in question. (This will   get any current __ct records processed)
   2. Under ‘Manage task’, duplicate the Full load task.
   3. Enable the ‘handle duplicate’ check box for the newly created Ful load.
   4. Generate instructions for the newly created task.
3. On the Qlik Replicate server:
   1. Reload all the tables for the task that you want to reprocess in Qlik Compose.
      Note: use DROP and recreate the target table option in ask settings under store change processing.
4. On the Compose server:
   1. Run the newly created Full load task <-- This is a one-time activity.
   2. Resume the original CDC task – This will continue to capture the changes while the newly created Full load task is running.
   3. Verify the data from the newly created Full load task.
   4. Remove the newly created Full load tasks.

Environment

Qlik Compose 
Qlik Compose for Data Warehouses 7.x