1183332 - How to design a job so Data Integrator doesn't wait for a long running Oracle package to execute before continuing execution of other Data Flows.

You have multiple Data Flows that extract from dimension tables, next an Oracle package is being called and then multiple Data Flows that load fact tables.  All are serialized.  The package is called with a SQL() call in a Data Integrator script.  It takes hours to complete and no other Data Flows are being executed during this time frame.  You want the fact loading Data Flows to execute while the package is being executed instead of waiting for it to complete.

parallel, serial , 167407 , KBA , EIM-DI , Data Integrator, Composer , How To