Siebel Data Warehouse Installation and Administration Guide > Upgrading Siebel Data Warehouse > Upgrade Requirements for Siebel Data Warehouse 7.7 >

Data Migration Workflows for Siebel Industry Applications Data Warehouse Upgrades

Siebel Industry Applications upgrade workflows include the following functionality:

SIA_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 data for all processed rows for all the tables.

SIA_Upgrade_Unspecifieds. This workflow contains mappings for modifying the Unspecified values of DATASOURCE_NUM_ID for each Dimension is loaded. It also modifies the Unspecified values for List Of Value Dimension, Activity Product Fact, Fund Fact, Medical Education Fact, Promotion Fact, Revenue Fact, Syndicated Data Fact, Syndicated Market Fact, and Vehicle Fact.

LS_Upgrade_ActivityProduct. This workflow contains mappings to update the Activity Product Fact with the PRD_CALL_IND & VIS_PR_POS_ID.

LS_Upgrade_Others. This workflow contains mappings to load Geo Wid to Position Contact Dimension. It also contains the mapping to update the Medical Education, Objective, Profile Rank, Syndicated Data, and Syndicated Market Fact with the VIS_PR_POS_ID.

SIA_Upgrade_Household. This workflow contains mapping to update INCOME_RANGE and INCOME_RANGE_I in W_HOUSEHOLD_D because the transactional database source is changed.

FINS_Upgrade_Visibility. This workflow contains mappings to update table_wid, which has changed in Analytics 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_ASSET_PARTY, W_CLAIM_PARTY, and W_HLDNG_PARTY.

SIA_UpgradeSlowlyChangingDimensionStartDates. This workflow contains mappings to update SCD_START_DT_WID, which has changed in this release. The Slowly Changing Dimensions tables that are modified in this workflow are W_ASSET_SCD, and W_INS_CLAIM_SCD & W_OPTY_SCD.