Bookshelf: Data Migration Workflows for Siebel Data Warehouse Data Upgrades

Siebel Data Warehouse Installation and Administration Guide > Upgrading Siebel Data Warehouse >

Data Migration Workflows for Siebel Data Warehouse Data Upgrades

Upgrading Siebel Data Warehouse data requires use of data migration workflows to migrate preconfigured content. The data upgrade process consists of the following Informatica workflows:

Upgrade_DAW. This workflow contains mappings to move data from the old set of system tables, such as S_ETL_RUN_S, which contains the run information, to the new table, W_ETL_DEFN_RUN, and so on.
Upgrade_R_Image. This workflow contains mappings to load the r_tables with data for the period instead of a monolithic r_image table consisting of data for all processed rows for all the tables.
Upgrade_Unspecifieds. This workflow contains mappings for modifying the Unspecified values for List Of Val, Product Attribute, Sub Set Dimension is loaded.
Upgrade_Agree. This workflow contains mappings to load the Agree mini dimension and update the Agree Dimension, Agree Fact and Agree Item Fact with the mini wid. Also columns SEX_MF_CD, SEX_MF_CD_I in W_PERSON_D and W_PERSON_SCD are updated. In addition column DATASOURCE_NUM_ID is set to 1 for the Unspecified rows as it has been modified in Analytics version 7.7.
Upgrade_Asset. This workflow contains mappings to load the Asset mini dimension and update the Asset Dimension and Asset Fact with the mini wid. Also, some denormalized columns are loaded to the Asset Fact.
Upgrade_Opty. This workflow contains mappings to load the Opty mini dimension and update the Opty Dimension, Revenue Fact, Opty Contact Fact and Pipeline Fact with the mini wid. Also, some denormalized columns are loaded to the Revenue Fact, Opty Contact Fact, and Opty Stage Fact, and Pipeline Fact.
Upgrade_Order. This workflow contains mappings to load the Order Mini Dimension and update the Order Dimension and Order Item Fact with the mini wid. Also some denormalized columns are loaded to the Order Fact. In addition, the Order Item Fact is now split into Order Fact containing only the header rows, and Order Item fact containing only the line item details the header rows that previously existed are deleted.
Upgrade_Quote. This workflow contains mappings to load the Quote Mini Dimension and update the Quote Dimension and Quote Item Fact with the mini wid. Also, some denormalized columns are loaded to the Quote Fact. In addition, the Quote Item Fact is now split into Quote Fact containing only the header rows and Quote Item fact containing only the line item details the header rows that previously existed are deleted.
Upgrade_Response. This workflow contains mappings to load the Response mini dimension and update the Response Dimension and Response Fact with the mini wid. Also some denormalized columns are loaded to the Response Fact.
Upgrade_ServiceRequest. This workflow contains mappings to load the ServiceRequest mini dimension and update the ServiceRequest Dimension and ServiceRequest Fact with the mini wid. Also, some denormalized columns are loaded to the ServiceRequest Fact.
Upgrade_Others. This workflow contains mappings to load Region to Geo Dimension and load Geo Wid to Person Dimension, Person SCD, and Org Dimension. Also, some denormalized columns are loaded into Survey and Activity Fact. In addition, columns VENDOR_NAME and PR_PROD_LN in W_PRODUCT_D and W_PRODUCT_SCD are modified.
Upgrade_Visibility. This workflow contains mappings to update table_wid, which have changed in Analytics version 7.7, and the previous source for the table_wid S_ETL_SRC_TABLE, which is deprecated in this release. The visibility tables that are modified in this workflow are W_ACT_PARTY, W_CON_PARTY, W_HHOLD_PARTY, W_OPTY_PARTY, W_ORDER_PARTY, W_ORG_PARTY, W_PROG_PARTY, W_QUOTE_PARY, W_RESP_PARTY, W_SEG_PARTY, and W_SR_PARTY.
UpgradeSlowlyChangingDimensionStartDates. This workflow contains mappings to update SCD_START_DT_WID, which has changed in Analytics version 7.7. The Slowly Changing Dimensions tables that are modified in this workflow are W_PERSON_SCD, W_HHOLD_SCD, W_PL_ITEM_SCD, and W_PRODUCT_SCD.

Siebel Data Warehouse Installation and Administration Guide
Published: 11 March 2004