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

Bishnu123 — Wed, 16 Jul 2025 02:55:56 GMT

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,

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

john_wang — Wed, 16 Jul 2025 15:39:07 GMT

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.

topic Re: Replicating One Source Table to Two Target Tables with Different Names in Same Task in Qlik Replicate

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

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