Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Customizing, Designing, Executing and Monitoring ETL Processes >

Building and Running an Execution Plan with the DAC

Execution plans are subject areas that are used to execute ETL processes. Before you attempt to run an execution plan, make sure you have completed the following:

• Set database connections to the transactional and data warehouse databases
• Registered the Informatica servers and repository server

To build and run an execution plan

1. Navigate to Execute > Execution Plans.
2. Create a new execution plan.
   1. In the top pane toolbar, click New.
   2. In the Edit child tab, enter a name for the execution plan and other appropriate information.

      For a description of the fields in this tab, see About the DAC Execution Plans Tab.

   3. Click Save.
3. Associate one or more subject areas with the execution plan.
   1. Click the Subject Areas child tab.
   2. Click Add/Remove in the bottom pane toolbar.
   3. In the Choose Subject Areas dialog box, select the appropriate source system container.
   4. Query for the subject area you want to associate with the execution plan.
   5. Select the subject area and click Add.

      You can associate multiple subject areas with an execution plan, but all the subject areas must be from the same source system container.

   6. Click OK to close the window.
4. Generate the runtime parameters.
   1. Click the Parameters child tab.
   2. Click Generate in the bottom pane toolbar.
   3. For each Datasource type, enter the appropriate name in the Value field.
5. In the top pane of the Execution Plans tab, make sure the new execution plan is highlighted, and click Build.

   The DAC builds the execution plan.

6. To run the execution plan, select the execution plan in the top pane, and click Run Now.

   Once the ETL process starts running you can monitor its progress in the Current Run tab.

   For information about how refresh dates are tracked, see About Refresh Dates.

   To schedule an execution plan, see Scheduling an Execution Plan.