Process flows can be designed using Oracle Warehouse Builder. Designing process flows is described in detail in the OWB User Guide.