topic Re: LOB column data is getting truncated while source_lookup in Qlik Replicate

LOB column data is getting truncated while source_lookup

gayatri235 — Tue, 12 Mar 2024 15:29:08 GMT

Hello folks,

we are doing fullload but the data is getting truncated at target.

Source: Postgresql

Target: Synapse Analytics

We did source_lookup for LOB columns , but the data is not complete at target .

Anonymous — Tue, 12 Mar 2024 21:42:26 GMT

Please ensure if the column datatypes in source db matches with target db.

Also, please ensure that the source_lookup is configured appropriately for LOB columns to retrieve complete data

Thanks
Naren

john_wang — Wed, 13 Mar 2024 01:51:45 GMT

Not sure what's the data type in Synapse, and what's the task settings, however please make sure:

1. The column length should be big enough to store the LOB

4. The Limit LOB size in task setting

Hope this helps.

John.