https://community.qlik.com/t5/Talend-Studio/Write-Clob-from-Oracle-db-into-File/m-p/2200214#M2770 <P><A href="https://community.qlik.com/s/profile/0053p000007LQwIAAW">@vanupama1605</A>&nbsp;, you can try to use talend Bidgata sprak job? run on EMR cluster and see can it bing to down? and you can use the remote execution option also.</P> Thu, 04 Jun 2020 07:58:42 GMT manodwhb 2020-06-04T07:58:42Z https://community.qlik.com/t5/Talend-Studio/Write-Clob-from-Oracle-db-into-File/m-p/2200213#M2769 <P>Hi&nbsp;</P> <P>I have a need to write a huge data set ( Clob from db) into a file.</P> <P>The size of data is expected to be around 25 GB with over 45 Million rows.&nbsp;</P> <P>Implemented this with tOracleInput, tJava and tFileOutputDelimited components. However the process takes forever to complete (Over 11 hrs)</P> <P>Any suggestions on how this can be improved</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:14:49 GMT https://community.qlik.com/t5/Talend-Studio/Write-Clob-from-Oracle-db-into-File/m-p/2200213#M2769 Anonymous 2024-11-16T02:14:49Z https://community.qlik.com/t5/Talend-Studio/Write-Clob-from-Oracle-db-into-File/m-p/2200214#M2770 <P><A href="https://community.qlik.com/s/profile/0053p000007LQwIAAW">@vanupama1605</A>&nbsp;, you can try to use talend Bidgata sprak job? run on EMR cluster and see can it bing to down? and you can use the remote execution option also.</P> Thu, 04 Jun 2020 07:58:42 GMT https://community.qlik.com/t5/Talend-Studio/Write-Clob-from-Oracle-db-into-File/m-p/2200214#M2770 manodwhb 2020-06-04T07:58:42Z