Sync All the Records Changed Transaction (CDC) to Target
Hi All,
I'm new to Qlik Replicate.
I've a requirement to sync all the records changes historical data into target table.
The source is IBM DB2 for iSeries and we read from Journal (CDC).
I did configure the replication task to sync into target table. But, it update the latest record into target table instead of send all changes historical (CDC) data into target.
Could advised how should I send all the CDC historical changes data into target table? e.g: If 1 record get update 5 times and this captured in CDC. I want this 5 CDC records get sync into target table.
To capture and sync all historical change data (CDC) from IBM DB2 for iSeries into the target table using Qlik Replicate, Task will capture all changes (INSERT/UPDATE/DELETE) instead of just applying the latest change. This approach is typically called Change Data Capture (CDC) with history.
Here’s how you can achieve that:
1. Enable Full History Logging:
In Qlik Replicate, you can configure the task to store each change (insert, update, delete) as a separate row in the target table.
To do this, you need to enable Store Changes in the task settings.
Steps:
Go to the Replication Task settings.
Navigate to the Change Processing tab.
Check the option for Store Change Settings.
This will store a record for every insert, update, and delete operation in the target table, ensuring all historical changes are captured.
2. Track Operation Type (Insert, Update, Delete):
To distinguish between different change operations (inserts, updates, deletes), Qlik Replicate adds an operation indicator column to the target table. This helps you track whether a row was inserted, updated, or deleted.
To capture and sync all historical change data (CDC) from IBM DB2 for iSeries into the target table using Qlik Replicate, Task will capture all changes (INSERT/UPDATE/DELETE) instead of just applying the latest change. This approach is typically called Change Data Capture (CDC) with history.
Here’s how you can achieve that:
1. Enable Full History Logging:
In Qlik Replicate, you can configure the task to store each change (insert, update, delete) as a separate row in the target table.
To do this, you need to enable Store Changes in the task settings.
Steps:
Go to the Replication Task settings.
Navigate to the Change Processing tab.
Check the option for Store Change Settings.
This will store a record for every insert, update, and delete operation in the target table, ensuring all historical changes are captured.
2. Track Operation Type (Insert, Update, Delete):
To distinguish between different change operations (inserts, updates, deletes), Qlik Replicate adds an operation indicator column to the target table. This helps you track whether a row was inserted, updated, or deleted.
