Write Clob from Oracle db into File

[Anonymous]

Hi 

I have a need to write a huge data set ( Clob from db) into a file.

The size of data is expected to be around 25 GB with over 45 Million rows. 

Implemented this with tOracleInput, tJava and tFileOutputDelimited components. However the process takes forever to complete (Over 11 hrs)

Any suggestions on how this can be improved

[manodwhb]

@vanupama1605 , 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.