topic Re: Json File handling in Qlik Replicate https://community.qlik.com/t5/Qlik-Replicate/Json-File-handling/m-p/2459755#M11403 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/242517">@Giriprasath</a>&nbsp;,</P> <P>From theory it's possible by using the&nbsp;<SPAN><A title="source_lookup() function" href="http://source_lookup(TTL,'SCHM','TBL','EXP','COND',%20 COND_PARAMS) Use to retrieve additional data from the source endpoint." target="_blank" rel="noopener">source_lookup() function</A>&nbsp;to retrieve the partial LOBs column from source table however this may reduce the replication performance.</SPAN></P> <P><SPAN>BTW, is this for a Full Load ONLY task, or for both Full Load and CDC enabled task? What's the source and target DB types?</SPAN></P> <P><SPAN>thanks,</SPAN></P> <P><SPAN>John.</SPAN></P> Thu, 06 Jun 2024 07:13:11 GMT john_wang 2024-06-06T07:13:11Z Json File handling https://community.qlik.com/t5/Qlik-Replicate/Json-File-handling/m-p/2459751#M11402 <P>Can i segregate the NCLOB column into Multiple single columns from source to target . Is that possible?</P> <P>&nbsp;</P> Thu, 06 Jun 2024 07:06:53 GMT https://community.qlik.com/t5/Qlik-Replicate/Json-File-handling/m-p/2459751#M11402 Giriprasath 2024-06-06T07:06:53Z Re: Json File handling https://community.qlik.com/t5/Qlik-Replicate/Json-File-handling/m-p/2459755#M11403 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/242517">@Giriprasath</a>&nbsp;,</P> <P>From theory it's possible by using the&nbsp;<SPAN><A title="source_lookup() function" href="http://source_lookup(TTL,'SCHM','TBL','EXP','COND',%20 COND_PARAMS) Use to retrieve additional data from the source endpoint." target="_blank" rel="noopener">source_lookup() function</A>&nbsp;to retrieve the partial LOBs column from source table however this may reduce the replication performance.</SPAN></P> <P><SPAN>BTW, is this for a Full Load ONLY task, or for both Full Load and CDC enabled task? What's the source and target DB types?</SPAN></P> <P><SPAN>thanks,</SPAN></P> <P><SPAN>John.</SPAN></P> Thu, 06 Jun 2024 07:13:11 GMT https://community.qlik.com/t5/Qlik-Replicate/Json-File-handling/m-p/2459755#M11403 john_wang 2024-06-06T07:13:11Z