Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2020-06-04 03:49 AM

Write Clob from Oracle db into File

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

 

Labels (2)
Labels
205 Views
0 Likes
1 Reply
manodwhb
Champion II
Champion II
‎2020-06-04 03:58 AM

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

205 Views
0 Likes