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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Contributor
- 578 replies
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?