Key modification on Target table

[ddb]

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

[Heinvandenheuvel · Accepted solution]

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.

[john_wang]

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.