Skip to main content

Good morning,

I have a question about FME

I have many readers and writers that transform files into oracle tables, and he reads everyone and does commit only after all. I would like you to conduct a commit every transaction from reader to writer

On your Oracle writer there's a Parameter called 'Features Per Transaction'. This parameter specifies how many features are written to the database before they are committed. It is usually a multiple of Bulk Write Size. It is possible to set this value to 1 but, it's likely to introduce a performance hit on you write speed.


On your Oracle writer there's a Parameter called 'Features Per Transaction'. This parameter specifies how many features are written to the database before they are committed. It is usually a multiple of Bulk Write Size. It is possible to set this value to 1 but, it's likely to introduce a performance hit on you write speed.

 

Nice... Is it possible, my second reader, to recognize the data of the first writer? I did the test, the first attempt was made the first writer, the second reader did not recognize. But when I ran the FME again, he recognized it. I would like this interaction in the first run. It's possible?