Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse >

Modifying Workflow Processes for Industry Applications


If you are using one of the following industry applications, you should modify the workflow processes to optimize the mappings for your industry.

If you do not modify the workflow processes, then every session in the workflow is processed. For example, if you use the Life Sciences application, you do not need the Automotive sessions contained within the workflow processes. You can safely remove all Automotive sessions. Leaving the sessions in the workflow process does not prevent the workflow from completing successfully, but it does take extra time to process. For optimum performance, it is recommended that you remove all sessions that do not apply to your industry.

The session names have a naming convention. Some session names are preceded by a prefix and an underscore ( _ ). Sessions that have no prefixes and sessions that begin with the SIA prefix are common to all industry applications and should be kept (example: SIA_SIL_AssetDimension). Sessions that are specific to an industry have a two-letter prefix that indicates the type of industry (example: LS_SIL_ProdRankDimension, where LS indicates Life Sciences). Table 22 has a listing of industries and sessions.

Table 22.  Industry and Applicable Session Prefixes
Industry
Prefixes
None
SIA
AT
CS
LS
Automotive
X
X
X
 
 
Communication
X
X
 
 
 
Consumer Sector
X
X
 
X
 
Energy
X
X
 
 
 
Life Science
X
X
 
 
X
Media
X
X
 
 
 

To remove sessions from a workflow process

  1. Start Informatica PowerMart Workflow Manager.
  2. Select the Siebel_DW_Rep repository.
  3. Edit the following workflow processes, removing sessions that do not apply to your industry.
    • Full_Extract_Siebel_DW_Vertical
    • Full_Extract_Siebel_DW_Fact
    • Full_Load_Siebel_DW_Dimension
    • Full_Load_Siebel_DW_Fact
    • Refresh_Siebel_DW_Dimension
    • Refresh_Siebel_DW_Fact
  4. Save the repository.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004