Oracle® Business Intelligence Data Warehouse Administration Console Guide > DAC Functional Reference > About the DAC Design View >

About the DAC Task Groups Tab


The Task Groups tab lists all the task groups associated with the selected source system container. A task can belong to only one group. Table 23 provides a description of the task group properties displayed in the top pane of the tab.

Table 23. Task Groups Tab Top Pane Properties
Column
Description

Restart All on Failure

Indicates the tasks in this task group will be restarted if one or more tasks fails during an ETL process.

Execute Serially

Indicates the tasks in this task group will be executed sequentially. This property overrides the execution order.

Truncate Always

Indicates the target tables are truncated regardless of whether a full or incremental load is occurring. Any indices registered for the target table are dropped before the command is executed and are recreated after the command completes successfully. When indices are dropped and created, the table is analyzed so that the index statistics are up-to-date.

NOTE:  Make sure if you select this option that all the tasks write to the same data source.

Truncate for Full Load

Indicates the target tables will be truncated only when a full load is occurring. Any indices registered for the target table are dropped before the command is executed and are recreated after the command completes successfully. When indices are dropped and created, the table is analyzed so that the index statistics are up-to-date.

Table 24 provides a description of the child tabs in the bottom pane of the Task Groups tab.

Table 24. Task Groups Child Tabs
Column
Description

Child Tasks

Lists the tasks that belong to the selected task group.

It includes the following properties:

  • Execution Order. Order among the tasks in the task group in which this task will be executed. If two or more tasks have the same execution order and the Execute Serially flag is not checked, the DAC will run the tasks in parallel.

Source Tables

Read only. Displays the tables used for getting data by the selected task group.

It includes the following properties:

  • Task. Task that extracts data from the table.
  • Primary. Indicates whether the table is a primary source of data.
  • Auxiliary. Indicates whether the table is a secondary source of data.
  • Type. Source table type.

NOTE:  If a table is marked as Primary or Auxiliary and the Build Image property of the task is selected, the change capture process is invoked. There are special tasks that force the base table data to be extracted when data in auxiliary tables changes.

A table can be neither Primary nor Auxiliary but still be used for getting some attributes to populate a dimension or fact table. The changes in these kinds of source tables are not reflected in the dimension or fact table once the data is populated.

Target Tables

Read only. Displays the tables into which the task group (selected in the top pane) loads data.

It includes the following properties:

  • Table. Name of the target table.
  • Task. Task that loads data into the target table.
  • Primary. Indicates whether the table is a primary target table. For documentation purposes only.
  • Auxiliary. Indicate whether the table is a secondary target table.
  • Type. Target table type.
Oracle® Business Intelligence Data Warehouse Administration Console Guide Copyright © 2007, Oracle. All rights reserved.