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

Creating a Task Group

The DAC automatically organizes tasks into a dependency structure based on dependency rules. For information about the DAC's dependency rules, see How the DAC Determines the Order of Task Execution within an Execution Plan. The DAC assigns priority randomly to tasks that have the same properties. You can use the Task Group feature to group such tasks that share the same properties and enforce a priority of your choosing.

This feature can be useful for the following: truncation and restartability purposes; when more than one task with similar properties writes to the same table; and when there is a circular read/write relationship between tables; for example, task 1 reads from table A and writes to table B, and task 2 reads from table B and writes to table A.

To create a task group

1. In the DAC, select the appropriate source system container from the drop-down list in the toolbar.
2. In the Menu bar, click Views > Design > Task Groups.
3. Create a new task group.
   1. Click New in the top pane toolbar.
   2. In the Edit child tab, enter a name and select the appropriate properties.
4. Click the Child Tasks child tab, and click Add/Remove in the toolbar.
5. In the left-hand window of the Choose Child Tasks dialog box, query for the tasks you want to add to the task group.
6. Select the tasks, and click Add.
7. In the right-hand window, enter an execution order.
8. Click Save, and then click OK to close the window.