problem with oracle bulk loader

One Star

problem with oracle bulk loader

Hi, I have a problem with tOracleBulkExec component. The job is very simple: just the component itself, with this configuration (see attached images for Basic, Advanced, Schema tab)
Attached:
- A 10 row sample file I want to load: 
- the .ctl file created by Talend
- The "log" file from the loader
- The "bad" file from the loader

The problem seems to be on the number format (Invalid Number on the COSUMO_STD field). I tried also to change the NLS Language component setting from "Default" to "AMERICAN", but it didn't change anything.
Thanks a lot,
Andrea



POST_BULK.zip_20141209-1742.zip
Highlighted
One Star

Re: problem with oracle bulk loader

Hi everybody,
any news? I'm in big trouble and I'm in a hurry, because it is a production enviroment and I need to load a big amount of data.
I'm not able to accomplish this task because of this issue.
Thank you everybody,
Andrea
Highlighted
One Star

Re: problem with oracle bulk loader

It was a number format problem, for what I understand numbers shouldn't have more than 12 decimals to be loaded with bulk loader. If I use a java round function to limit the decimals, the bulk load works with no errors.
Highlighted
One Star

Re: problem with oracle bulk loader

Hi
I have the same problem with bulk insert and to get round it I load data in string format.
The other problem that I have is the ROWS PER COMMIT : I specified 1000000 but I have only 3 rows per commit. Could somebody help me?
Thanks a lot.
Otmane.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog