hi all ,
my file adapter reading file that is csv file . csv file has 1,00,000 records file adapter reading the file.
now i have to insert those records into db when inserting i used flowN for parallel execution but records not inserting into db.
When i am using transform records are inserted into db.
so how many dynamic parallel flows FlowN activity can generate.
and i increase records to 10,00,000 then transforms also file.
please provide solution for this
Edited by: Mohan SOA on Aug 8, 2012 10:20 PM
Edited by: Mohan SOA on Aug 13, 2012 12:44 AM
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.
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.