Task Groups

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.

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 indexes registered for the target table are dropped before the command is executed and are recreated after the command completes successfully.

 When indexes are dropped and created, the table is analyzed so that the index statistics are up-to-date.

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 indexes registered for the target table are dropped before the command is executed and are recreated after the command completes successfully. When indexes are dropped and created, the table is analyzed so that the index statistics are up-to-date.

Task Groups Tab: Child Tasks Subtab

The Child Tasks subtab lists the tasks that belong to the selected task group. It also enables you to add child tasks to a task group selected in the top window.

Primary Source

Logical database connection for the primary source database.

Primary Target

Logical database connection for the primary target database.

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.

Task Groups Tab: Source Tables (RO) Subtab

The Source Tables (RO) subtab lists the tables used for extracting data by the selected task group.

Table

Name of source table.

Task

Task that extracts data from the table.

Type

Source table type.

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.

Task Groups Tab: Target Tables (RO) Subtab

The Target Tables (RO) subtab is a read-only tab that lists the tables into which the task group loads data.

Table

Name of the target table.

Task

Task that loads data into the target table.

Type

Type of target table.