Bookshelf v7.5.3: Refresh Optimizer Settings in Oracle

Table 21. Predefined Refresh Workflow Processes
Workflow 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 transactional database. When this workflow process completes, you can view the results in the Siebel Data Warehouse Analytics Administration view. For more information, see 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 workflow 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: Person — Marital status Household — Net worth (Wealth amount) Product — Product Name
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 further information on the population process, including error recovery, see the documentation from Informatica, specifically, the Designer guide, session and server guide, and troubleshooting guide.