The information in this article is provided as-is and to be used at your discretion. So, please implement and test this in the testing environment before applying this to production.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
- On Replicate Server: Stop the task for the table in question
- On the Qlik Compose server:
- Run the CDC task for the table in question (this will get any current __ct records processed)
- Under ‘Manage task’, duplicate the Full load task for the table in question
Note: Make sure to select the ‘Full load Only’ option under the task type
![Nanda_Ravindra_0-1654575069066.png Nanda_Ravindra_0-1654575069066.png](https://community.qlik.com/t5/image/serverpage/image-id/81092i75FE2087D72110BE/image-size/small?v=v2&px=200)
- Enable the ‘handle duplicate’ check box for the newly created task that you created by duplicating the Full load task in Step#2B
- Generate instructions for the newly created task.
- On the Qlik Replicate server:
- Reload the table in question and start the task
- On the Qlik Compose server:
- Run the newly created Full load task <-- This is a one-time activity.
- Verify the data.
- Remove the newly created Full load task.
- Resume the CDC task.
Environment
Qlik Compose all versions
Qlik Compose for Data Warehouses Data Warehouse 7.x