Replicating One Source Table to Two Target Tables with Different Names in Same Task

[Bishnu123]

Dear Qlik Support,

I am currently working with Qlik Replicate and would like to understand the best approach to replicate a single source table into two separate target tables with different names within the same replication task.

My setup details are as follows:

• Source: DB2 LUW

• Target: Amazon Redshift

• Task Type: Full Load with Change Data Capture (CDC) enabled

My goal is to replicate the source table employees to two different target tables:

• employees (as the original)

• employees_audit (as a backup or audit version)

Can you please confirm if this setup is supported in Qlik Replicate under the same task? If so, could you provide guidance or best practices on how to configure the task to include the same source table twice with different target names?

Any considerations or limitations specific to DB2 LUW and Redshift in this context would also be helpful.

Thank you,

[john_wang · Accepted solution]

Hello @Bishnu123 ,

Qlik Replicate supports running two Change Processing modes concurrently. In this scenario, both of the following modes need to be enabled:

1- Apply Changes

2- Store Changes

Hope it helps.

John.