Running IWE Control Flows

Follow these steps to run the IWE Control Flows:

1. In the IWE Design Studio Data Source Explorer window ensure that these 3 Database Connections are connected to their Databases:
   • curamdb
   • curamdw
   • curamdm
2. In the Data Project Explorer open the CuramBIWarehouse\Control Flows folder
3. Run the Core Control Flows in this order - they will in turn run all of the Data Flows:
   • CuramStagingCoreStaticFlow.cflowxmi
   • CuramStagingCoreOperationalFlow.cflowxmi
   • CuramWarehouseCoreStaticFlow.cflowxmi
   • CuramWarehouseCoreLookupFlow.cflowxmi
   • CuramWarehouseCoreOperationalFlow.cflowxmi
   • CuramDatamartCoreStaticFlow.cflowxmi
   • CuramDatamartCoreLookupFlow.cflowxmi
   • CuramDatamartCoreOperationalFlow.cflowxmi
   • CuramDatamartCoreMonthlyAggregateFlow.cflowxmi
4. If you have CCS and IS then run the Control Flows in this order:
   • CuramStagingCoreStaticFlow.cflowxmi
   • CuramStagingCoreOperationalFlow.cflowxmi
   • CuramStagingCCSOperationalFlow.cflowxmi
   • CuramStagingISOperationalFlow.cflowxmi
   • CuramWarehouseCoreStaticFlow.cflowxmi
   • CuramWarehouseISStaticFlow.cflowxmi
   • CuramWarehouseCoreLookupFlow.cflowxmi
   • CuramWarehouseCCSLookupFlow.cflowxmi
   • CuramWarehouseISLookupFlow.cflowxmi
   • CuramWarehouseCoreOperationalFlow.cflowxmi
   • CuramWarehouseCCSOperationalFlow.cflowxmi
   • CuramWarehouseISOperationalFlow.cflowxmi
   • CuramDatamartCoreStaticFlow.cflowxmi
   • CuramDatamartCoreLookupFlow.cflowxmi
   • CuramDatamartCCSLookupFlow.cflowxmi
   • CuramDatamartISLookupFlow.cflowxmi
   • CuramDatamartCoreOperationalFlow.cflowxmi
   • CuramDatamartCCSOperationalFlow.cflowxmi
   • CuramDatamartISOperationalFlow.cflowxmi
   • CuramDatamartCoreMonthlyAggregateFlow.cflowxmi

The Data Warehouse Tables should now be populated with the data that was in the Source Application Database Tables.