Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi @gayatri235
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
Hello @gayatri235 ,
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
2. Replication of records exceeding 1 MB is not supported
3. Full LOB replication is not supported
4. The Limit LOB size in task setting
Hope this helps.
John.