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
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.
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 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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch