One Star

[resolved] using bulk load with talend

Hi 
please help me I'm so blocked 
i have 8 files format .txt  and each file has a 1GB like a size , my mission is to load this 8 fiels into an oracle table 
i use the component tfilelist, tfileinputdelimited and toracleoutputbulkexec but it does'nt work 
because the .ctl file generated by toracleouputbulkexec make the colums of the table between double cotes 
so how can i do this there is any solution for my problem 
how can i load the 8 files which are so big into a oracle table using sql loader 
pleaase help me 
Thanks
4 REPLIES
One Star

Re: [resolved] using bulk load with talend

I suggest use tOracleBulkExec component instead.  
One Star

Re: [resolved] using bulk load with talend

Thanks Mike-West for your reply 
can you explain to me how i use toraclebulkexec and how you make the ctl file 
and you make for all the files 
Thanks
One Star

Re: [resolved] using bulk load with talend

tOracleBulkExec component simply loads a file using sql*ldr.   It will create the .ctl file for you based on the schema.  It also has an option for you to supply your own control file in advanced settings "use existing ctl file" if you prefer.
Seventeen Stars

Re: [resolved] using bulk load with talend

hi all,
here's the scenario from Talend help :
https://help.talend.com/search/all?query=tOracleBulkExec&content-lang=en
... or press F1 from your studio to got some quick help Smiley Wink
regards
laurent