topic [resolved] using bulk load with talend in Talend Studio

[resolved] using bulk load with talend

Anonymous — Sat, 02 Aug 2014 17:51:14 GMT

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

Re: [resolved] using bulk load with talend

Anonymous — Mon, 04 Aug 2014 17:02:35 GMT

I suggest use tOracleBulkExec component instead.

Re: [resolved] using bulk load with talend

Anonymous — Mon, 04 Aug 2014 17:29:01 GMT

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

Re: [resolved] using bulk load with talend

Anonymous — Mon, 04 Aug 2014 17:52:18 GMT

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.

Re: [resolved] using bulk load with talend

Anonymous — Tue, 05 Aug 2014 08:51:35 GMT

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
regards
laurent