Four Stars

tOracleOutputBulk -tOracleOutputBulkExec

Hi,

I have a file csv that I want to load in a Oracle Database by using tOracleOutputBulkExec because it is very big. Can you sho me a solution please?? 

 

This is my job

Immagine.jpg

  • Big Data
  • Data Integration
2 ACCEPTED SOLUTIONS

Accepted Solutions
Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

Hi,

I suppose the output flow shcema for the tMap component is aligned on the tOracleOutputBulkExec.

So, what's the problem? You just have to link the tMap to the tOracleOutputBulkExec using the flow definde in tMap.

Or do you have a specific problem not exposed in your initial question?


TRF
Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

As I remember, the default extension for sqlldr is ".dat", so name the file according to this rule.

TRF
10 REPLIES
Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

Hi,

I suppose the output flow shcema for the tMap component is aligned on the tOracleOutputBulkExec.

So, what's the problem? You just have to link the tMap to the tOracleOutputBulkExec using the flow definde in tMap.

Or do you have a specific problem not exposed in your initial question?


TRF
Four Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

Yes, i've link them but talend send me a message and then i don't understand what is name file in tOracle.
Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

As for any tXxxxxOutputBulkExec component, the records are written into a file by the component itself using the format expected by the database or application you want to write into. So you don't have to know this format, just concentrate on what you want to transfer, not how to do that.

So, the filed "Filename", is the name of this file, not the name of the input file (and sometimes, there is not inputfile, for example if the source is an other database).

What is the message you received?

Is it a compilation error or a runtime error?


TRF
Four Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

I don't understand again. 

 

My job is:

Immagine.jpg

 

 

and my file csv is in this position:

Immagine4.jpg

 

 

My tMap is:

Immagine.png

 

And i lin it with tOracleOutputBulkExec, but i don't understaind again the filename:

Immagine3.jpg

 

and talend send me this error message:

Immagine2.jpg

 

I have install Oracle in the Virtual Machine and now i'm working on the localhost. The component tOracleOutput is ok but is is very slow so i want use the bulkOracle.

 

Thanks again

Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

When you try to use tOracleOutputBulk operations, you need to install 1st sqlldr which is the dedicated Oracle tool to load external data into databases. This should solve the error you get when running the job (cannot run program "sqlldr").

Regarding the filename in tOracleOutputBulkExec, just use the filename you want (not the name of an existing file).

This file will be used by sqlldr when called by the job at runtime.


TRF
Four Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

If i run the job from VM but talend send me a message: unable to open file .dat . I have insert a filename without extencion.
Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

As I remember, the default extension for sqlldr is ".dat", so name the file according to this rule.

TRF
Four Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

Hi,

I'm sorry if i answer you so late. Thanks again for your help!

Now I have another problem with the bulk load Smiley Sad. In particolar I have a problem with the timestamp format. When I load the timestamp with the tOracleOutputBulkExec, the timestampo contain hour, minutes and second set on 00:00:00.

Seven Stars TRF
Seven Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

I suggest you to open a new topic for this new challenge.
Also, indicate the expected format for this field.

TRF
Four Stars

Re: tOracleOutputBulk -tOracleOutputBulkExec

HI, I've already post my problem in a new topic