Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse >

Configuring Slowly Changing Dimensions

The Siebel Customer-Centric Enterprise Warehouse provides Type II slowly changing dimension (SCD) functionality, which allows you to track the history of updates to dimension records. When a record in the Siebel Customer-Centric Enterprise Warehouse has an update, the updated information is posted into a new row and the old information is kept for historical reporting purposes.

The Siebel Customer-Centric Enterprise Warehouse identifies and applies the slowly changing dimension logic chosen by the user after data has been extracted and transformed to be source-independent, as shown in Figure 25. Users may configure the Source Adapter mapplet to support both Type I SCDs, in which data is overwritten with updates, and Type II SCDs, in which the original records are maintained while a new record stores the updated data. Choosing Type I or Type II SCDs depends on identifying your historically significant attributes.

Figure 25. Slowly Changing Dimension Logic Flow