This content has been marked as final. Show 5 replies
Hi,1 person found this helpful
there is no as such limits on FlowN threads, it will consume your heap size.
In this scenario it is not recomended to use FlowN activity. You better go with transformation and insert adapter.
Let me know the requirement if it is very specific to parallel insertion.
Not specific. i think if i use flowN activity the will will inserted in parallel way so time will reduce in transform activity sequential execution.
that's way i used flowN activity. But when i am transfering 1,00,000 records flowN failed to transfer the records. that's way i asked is there any limit for flowN activity to generate parallel flows.
Hi Mohan,1 person found this helpful
BPEL supports your payload upto 7 MB data size if it exceeds that limit it wont process your request properly.
I would like to sugget you to use ODI (Oracle Data Integrator) tool for such bulk loads, now days it comes as oracle fusion stack only.
i will try with ODI, If any doubts i will get back you
Ok, just give try and let me know.