Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Populating the Initial Siebel Data Warehouse >
Refresh Optimizer Settings in Oracle
Table 6 lists and provides a description of the refresh batch processes.
Table 6. Predefined Refresh Batch Processes Batch Name Description Exception_Reports This produces an exception report, which checks for data integrity of the Siebel Data Warehouse. This should be run before running Full_Load_Siebel_DW or Refresh_Siebel_DW. The results of the exception report can be used to make necessary corrections to the Siebel Transaction Database.When this batch process completes, you can view the results in the Siebel Analytics' Analytics Administration view. For more information, read Using the Exception Report and Diagnostic Views. Refresh_Extract_Siebel_
DW_Horizontal Contains all horizontal processes. Refresh_Extract_Siebel_
DW_Vertical Contains all vertical enhanced processes. Refresh_Load_Siebel_
DW_Dimensions Incrementally extracts from the Siebel Transactional Database changes to the source data since the most recent batch executed. However, the General tables (W_PARAM_G, W_COSTLST_G, W_LST_OF_VAL_G, W_EXCH_RATE_G) and Day Dimension (W_DAY_D, W_TIME_DAY_D, W_MONTH_D, W_QTR_D) are not reloaded or updated. Refresh_Load_Siebel_
DW_Facts All the Facts are incrementally loaded and updated. The Hierarchy and Position Helper tables are truncated and reloaded. It also updates those fields in the Dimension tables that need to be calculated from the Facts and also refreshes Price List Slowly Changing Dimension. Refresh_Load_Siebel_SCD Loads into the Slowly Changing Dimension Table when the following attributes change in the Dimension: Load_Aggregates Truncates the Sub-Dimensions and the Aggregate tables and loads the aggregate Data. Load_Pipeline Loads into Pipeline Fact the snapshot of the Opportunity Header rows in Revenue Fact. All open opportunities and opportunities closed in the current quarter form the snapshot. This should be typically run once a week. Visibility_Refresh Refreshes the visibility information. Please choose to run this when deemed necessary.For a complete understanding of the population process, including error recovery, read the documentation from Informatica, specifically, the Designer guide, session and server guide, and troubleshooting guide.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |