topic Re: Primary Key not being created in target tables in Qlik Replicate

Primary Key not being created in target tables

Anonymous — Fri, 12 Aug 2022 09:05:38 GMT

Hello,

I have a task with SAP Application endpoint as source, and AWS Redshift endpoint as target. The tables in SAP have primary keys detected by Qlik (shown in the table selection tab, see image).

But when doing a full load on target, with the drop and create option selected (see image), the tables created in Redshift have not the primary keys.

Why is this happening?

Re: Primary Key not being created in target tables

shashi_holla — Fri, 12 Aug 2022 14:35:32 GMT

Hi @Anonymous

We just tried on the 2022.05 version of Replicate and primary keys are getting replicated to Redshift. Could you please let us know your Replicate version and also if you enable the checkbox "Create Primary key or unique indes after Full Load completes" in Full Load settings, does it make any difference.

Please let me know.

Thank you,