Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to replicate a table from MS SQL Server to SF, and setting the task to be Full Load only. This table has an LOB column and it has no PK.
Per the post attached below: "A full load-only task can get around a limitation with LOB columns that are in a table with no primary key.", I followed the post to set the task so that "Full Load Processing is ON", but the LOB column is still skipped when loading.
https://community.qlik.com/t5/Official-Support-Articles/An-Introduction-to-Qlik-Replicate-Tasks-Full...
Could you please kindly advise if this is not a valid walkaround, and the only solution is to add PK to the source table?
>>> So looks like it is the change processing set to ON which triggers the LOB column loading issue?
Yes, as was indicated in every single reply thus far.
Hein.
Understand.
And as a follow up, will change processing work properly for both of the conditions below:
1. PK is available for the table with LOB columns
2. MS SQL Server CDC enabled for the table with LOB columns but without PK
thank you so much for your great support! @ruili