Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > DAC Functional Reference > About the DAC Design View >
About the DAC Task Definitions Tab
The Task Definitions tab displays a list of tasks in the top pane. Table 27 provides a description of the task properties displayed in the list.
Table 27. Task Definitions List Columns A table can be loaded in Full Mode or Incremental Mode. Full Mode refers to data loaded for the first time or data that is truncated and then loaded. Incremental Mode refers to new or changed data being added to the existing data.The DAC maintains a last refresh timestamp whenever a table is changed during the ETL process. (You can view this timestamp under Design > Tables > Database Connections or Setup > Database connections > Tables.) If a table has a timestamp, the command appearing in this column is executed. If a table does not have a timestamp, the command for a full load is executed. If the execution type is Informatica, the workflow name is used as the command.
- Informatica. Task is invoked on an Informatica server using pmcmd.
- External Program. Task is an operable program on the operating system where the DAC server is running. This program can be a batch file, shell script, or any other program that can be run like a bulk loader.
- SQL File. Task is a SQL script in .xml or .sql format. For more information, see Using SQL Files as an Execution Type in the DAC.
- Stored Procedures. Task is a stored procedure that has been defined on the databases.
In addition, there are several internal execution types that you will not be able to select when creating new tasks. These tasks are categorized as either internal change capture tasks or internal data warehouse tasks; all of these tasks are color-coded in pink in the Task Definitions tab.
- IMG_BUILD - internal change capture. If you are using multiple Siebel transactional sources, you cannot change the behavior of the change capture process. This task requires change capture tables to be created on the other sources also. When adding additional Siebel sources, go to Setup > Database Connections and select the appropriate Siebel source, right-click and select Change Capture Tasks. This action generates change capture tasks. Use this same action to disable or delete change capture tasks.
- IMG_SYNC - internal change capture. If you are using multiple Siebel transactional sources, you can create this task for the additional tasks for doing similar change capture sync processes. You cannot change the behavior of the change capture sync process. This task requires change capture tables to be created on the other sources also. This task should be used with discretion for Siebel sources only.
- QUERY_INDEX - internal data warehouse. This task allows you to alter when the Query indices are created. The DAC server drops all indices before loading when the CreateQueyIndexesAtTheEnd setting is set to True. When this setting is set to False, all the indices, regardless of the index type, get created as part of the task that does the loading.
- UPDATE_ETL_PARAM - internal data warehouse. This task is used for only to update W_PARAM_G from the DAC server. This task populates the preferences to the W_PARAM_G table in the Data Warehouse by querying values defined in the DAC repository. Because only one Data Warehouse per DAC repository is supported, this execution type should not be chosen for any task.
When this check box is selected, the target tables are truncated regardless of whether a full or incremental load is occurring. Any indices registered for this 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. When this check box is selected, the target tables are truncated only when a full load is occurring. Any indices registered for this 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. When the Truncate Always option is selected, this option has no meaning. When one or more optional prerequisite tasks (Depends On tasks) is run, the task is also included if this check box is selected. Otherwise, the task is ignored.For example, when table W_Person_F is loaded, W_Person_D is also loaded. However, the task UpdateRecencyCat in Person Dimension that writes to W_Person_D is optional. Only when the tasks Load into OrderDimension or Load into OrderItemFact (optional dependencies) are run does UpdateRecencyCat in Person Dimension need to be executed. So, this optional task will not be executed unless one or more of the tasks that it is depending on optionally is chosen for execution.Table 28 provides a description of the tabs in the bottom pane.
Actions Available
The following actions are available in the top pane toolbar and in the right-click menu when the Task Definitions tab is active.
Copy Record
This command creates a copy of the selected task and also copies the references to the tasks it depends on and source and target tables.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |