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 >
Full Load Optimizer Settings in Oracle
Table 20 lists and provides a description of the full load workflow processes.
NOTE: 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 20. Predefined Full Load Workflow Processes 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. Truncates the Image tables (S_ETL_I_IMAGE and S_ETL_R_IMAGE) and the S_ETL_RUN table on the Siebel transactional 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 transactional database. It also truncates and loads Day Dimension (W_DAY_D) and List of Values Dimension (W_LOV_D). Truncates the Image tables (S_ETL_I_IMAGE and S_ETL_R_IMAGE) and the S_ETL_RUN table on the Siebel transactional 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 transactional database. It also truncates and loads Day Dimension (W_DAY_D) and List of Values Dimension (W_LOV_D). 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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |