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

Setting a Task Phase Dependency

A task phase dependency allows you to change the order in which tasks are executed. When you set a task phase dependency, you work with three properties:

• Action. The action to be taken in relation to the phase dependency. Possible values are the following:
  • Wait. Allows you to set a task to wait for other tasks of a specified phase to be completed before it runs.
  • Block. Allows you to block all tasks of a specified phase from being executed until the specified task has been executed.
• Grain. Applicable only for blocks. Allows you to specify whether the action you choose affects all tasks of a specified phase or related tasks. (You can view a task's related tasks by navigating to Execution Plans > All Dependencies and viewing the specified task's predecessor tasks.)

  Possible values are:

  • All. Indicates the action will affect all tasks.
  • Related. Indicates the action will affect only related tasks. You can view a task's related tasks by navigating to Execution Plans > All Dependencies and viewing the specified task's predecessor tasks.
• Phase. The phase that applies to the action you choose.

To set a task phase dependency

1. In the DAC toolbar, select the appropriate source system container from the drop-down list in the toolbar.
2. In the Menu bar, click Views > Design > Tasks.
3. Query for the task for which you want to add a phase dependency, and make sure it is highlighted.
4. Click the Phase Dependency child tab.
5. Click Add/Remove.
6. In the Choose Phases dialog box, select a phase and click Add.
7. Click OK in the message box that states the phase was added.
8. Select an Action and a Grain, click OK.

   The task phase dependency appears in the Phase Dependency child tab.

9. Reassemble the appropriate subject area.
   1. In the Subject Areas tab, query for the appropriate subject area.
   2. Click Assemble.
10. Rebuild the execution plan.
    1. Navigate to the Execution Plans tab in the Execute view.
    2. Query for the appropriate execution plan.
    3. In the Parameters child tab, click Generate.
    4. In the top pane toolbar, click Build.