topic Key modification on Target table in Qlik Replicate

Key modification on Target table

ddb — Tue, 26 Mar 2024 14:38:20 GMT

What steps should be taken if I need to modify combination of primary key in the LogStream and target table?

Re: Key modification on Target table

Heinvandenheuvel — Tue, 26 Mar 2024 19:36:30 GMT

You will want to make any target table key changes in the child task (which writes to the target from the logstream).

In the GUI just click on the 'key' column checkmark for the selected fields, in the proper order. I'd recommend to review the result, notably the order in an exported task JSON.

Having the desired columns marked allows Replicate to (drop and) (re)create the target tables. Alternatively you could pre-create the target as desired and let Replicate load ' donothing' or 'truncate' on load.

In the User Guide look under "Transform actions " item "Set a column as a primary key/unique key or disable a column's primary key/unique key " it reads "Select the desired row in the Output table and then click the cell in the Key column. A key icon will be displayed"

note: Perhaps you'll get a more useful answer if you provide a more useful description of what is trying to be accomplished and why.

Hein.

Re: Key modification on Target table

john_wang — Wed, 27 Mar 2024 02:18:03 GMT

Besides @Heinvandenheuvel comment, if the source DB is Oracle please take note that including all the PK/UI columns (in both local task and replication task) into supplemental logging to make sure these columns values are not null.

Hope this helps.
John.