Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a source table that is partitioned. I did not create the schema for the table in the target before replication and let Qlik handle schema creation. Once replication was complete, I found that the target table was not partitioned. How can i ensure that when the source table is partitioned, the target is partitioned as well?
Hello @shekhar0413 ,
Yes, you are correct:
1- Qlik Replicate cannot create partition table (as target table) at present;
2- If the table is pre-created with partitions then it works for Qlik Replicate. You just need to change the Full Load Option Target Table Preparation to "TRUNCATE before loading" or "Do Nothing", as:
Hope this helps.
John.
Hello @shekhar0413 ,
Thanks for reaching out to Qlik Community!
This is not supported yet in the current major versions. BTW, What's the source and target databases types?
thanks,
John.
Replicate concerns itself strictly and only with the row data itself, and where available a primary / unique key to facilitate updates and deletes.
Anything else, like additional indexes, constraints need to be added separately, outside Replicate control.
For some target attributes, like partitioning, this may mean that the target table needs to be pre-created and the task settings changed to 'do nothing' for existing target tables.
Note, you any table which does not exist will be created as usual, even in 'do nothing' setting.
Hein.
Hi @john_wang, thanks, the source is DB2 and the target is Google Cloud AlloyDB.
Hi @Heinvandenheuvel, thanks for the response. So, if I pre-create the table as a partitioned table in the target, and then do a full load, then the data should be populated according to the appropriate partitions. Is my understanding correct?
Hello @shekhar0413 ,
Yes, you are correct:
1- Qlik Replicate cannot create partition table (as target table) at present;
2- If the table is pre-created with partitions then it works for Qlik Replicate. You just need to change the Full Load Option Target Table Preparation to "TRUNCATE before loading" or "Do Nothing", as:
Hope this helps.
John.
Hi @shekhar0413
I do not know if it is feasible to add this feature to the software, but we encourage you to submit a feature request here if this is something you would like added: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas
Thanks,
Dana