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.
|