Bookshelf v7.5.2: Full Load Optimizer Settings in Oracle

When doing full loads with Oracle Data Warehouse only, the optimizer rule should be set to Rule based in the init.ora parameters (OPTIMIZER_MODE RULE).

Table 5. Predefined Full Load 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.
Full_Extract_Siebel_ DW_Horizontal	Truncates the Image tables (S_ETL_I_IMAGE and S_ETL_R_IMAGE) and the S_ETL_RUN table on the Siebel Transaction Database, and the General and System tables (W_PARAM_G, W_COSTLST_G, W_LST_OF_VAL_G, W_EXCH_RATE_G, W_DIM_TABLES_G, W_DUAL_G, W_ETL_RUN_S, and so on) in the Siebel Data Warehouse. It extracts all the horizontal data from the Siebel Transaction Database. It also truncates and loads Day Dimension (W_DAY_D) and List of Values Dimension (W_LOV_D).
Full_Extract_Siebel_ DW_Vertical	Truncates the Image tables (S_ETL_I_IMAGE and S_ETL_R_IMAGE) and the S_ETL_RUN table on the Siebel Transaction Database, and the General and System tables (W_PARAM_G, W_COSTLST_G, W_LST_OF_VAL_G, W_EXCH_RATE_G, W_DIM_TABLES_G, W_DUAL_G, W_ETL_RUN_S, and so on) in the Siebel Data Warehouse. It extracts all the vertical data from the Siebel Transaction Database. It also truncates and loads Day Dimension (W_DAY_D) and List of Values Dimension (W_LOV_D).
Full_Load_Siebel_ DW_Dimensions	Truncates the dimensions and slowly changing dimensions and loads all the data extracted by Full_Extract_Siebel_DW for the Dimensions.
Full_Load_Siebel_ DW_Facts	Truncates the facts, hierarchy tables and helper tables in the Siebel Data Warehouse. It loads all the data extracted by Full_Extract_Siebel_DW for the Facts. It also updates those fields in the Dimension tables that need to be calculated from the Facts and also loads PriceList Slowly Changing Dimension besides loading Hierarchy and Helper tables.
Full_Load_Siebel_ DW_SCD	Loads into the Slowly Changing Dimension Table when the following attributes in the Dimension change: 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_Initial_Load	Truncates the visibility tables and load the Visibility information into the Visibility Tables.