[resolved] bulk insert in TOS :toracleoutputbulk and toraclebulkexec

One Star

[resolved] bulk insert in TOS :toracleoutputbulk and toraclebulkexec

Hi Talend pro,


I read talend's documentation and the posts for the two components for bulk insert but i have some questions

can you explain to me :
what the relation between toracleoutputbulk and toraclebulkexec ?
in the component toracleoutputbulk why should i define the file name in its basic settings ?? and this file is used by the toraclebulkexec for inserting data in the table ?
i know that this component write in the disk that's why it so performant then toracleoutput
and i want use a control file : should i indicate in the infile the path of the file name of the toracleouptputbulk ?

also can I use tfileinputdelimited-->tmap--->toracleouputbulk --> onsubjobok > toraclebulkexec

the tmap just for change order of rows and add some expressions ?



Thanks for your great help
Community Manager

Re: [resolved] bulk insert in TOS :toracleoutputbulk and toraclebulkexec

Hello
The tOracleOutputBulk and tOracleBulkExec components are always used together in a two step process. First, output the result to a text file, and then load the data into database with Oracle SQL loader.
If there already exists a control file, check the 'Use existing ctrl file' box in the advanced setting panel of toraclebulkexec and specify the file path of control file.

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] bulk insert in TOS :toracleoutputbulk and toraclebulkexec

Hi Shong,

I really need your help, i try to make it work but i don't know how Smiley Sad
I post many times in talend's forum but i don't have the answer of my problem, 
I have 8 files which has a size 1GB every fileso i should use bulk mode insert
after documentation, the toracleoutputbulk  prepare the file that toraclebulkexec load in the database son i don't need this component to prepare the data, i should use only the bulkexec 
but i don't know how i make my job like this :
tfileList-->tinputfiledelimited--iterate-->toraclebulkexec 
and in the parameters i don't konw how 
please help i'm blocked 
Thanks 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch