Bookshelf Home | Contents | Index | PDF |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > About Domain Values > About the Domain Value Conversion ProcessTo best understand the domain value conversion process, consider an example of two source systems—Source System A and Source System B. Each source system stores two types of employee events—hire and rehire. Source system A uses H to denote a hire event and R to denote a rehire event, whereas source system B uses 1 to denote a hire event and 2 to denote a rehire event. When the Siebel Customer-Centric Enterprise Warehouse extracts data from both systems, it ports those source values through the extract mapping until the data reaches the The load mapping then ports the extracted source values (H and R from source system A, and 1 and 2 from source system B) into the Source Adapter mapplet. Within the Source Adapter, source values are translated into domain values (HIR and REH) based on a set of rules that are particular to your business practices. Preparing to Define the RulesYou must define the rules so that the Source Adapter knows how to map your specific source values to the given set of domain values. Before you set up the rules you must:
Figure 34 illustrates how the source values are converted to the domain values—HIR and REH. Figure 35 illustrates a different situation where the records may not contain a source value that flags the record as Hire or Rehire. In this case, the source system stores hires in one table and rehires in another table. To make this work, one possible solution is to modify the extract mappings to populate the After the Source Adapter mapplet converts the source-specific values to domain values, the domain values are inserted into a Siebel Customer-Centric Enterprise Warehouse table. In this example, the HIR and REH values populate the |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |