4.2.2.2 Slowly Changing Dimensions (SCD)

A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse.

The following are the three types of SCDs:

• Type 1 SCDs -Overwriting
• Type 2 SCDs -Creating another Dimension Record
• Type 3 SCDs -Creating a Current Value Field

For information about the Type 1, Type 2, and Type 3 SCDs, see the Slowly Changing Dimensions (SCD) section in the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0

1. To navigate to the Slowly Changing Dimension Summary Page, from OFSAAHome, select Financial Services Balance Computation Engine, select Administration, select Data Management Tools, and select Slowly Changing Dimension.

   Figure 4-6 Slowly Changing Dimension Summary Page

   
   

   

   
   

   To perform different actions related to the SCD, see the following sub-sections in the Slowly Changing Dimension (SCD) section of the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0:

   • Creating Slowly Changing Dimension section to create an SCD or to define an SCD
   • Executing SCDs section to execute an SCD
   • Modifying SCD Definition section to edit an existing SCD Definition
   • Viewing SCD Definition section to view an existing SCD
   • Purging SCD Definitions section to remove the deleted SCDs permanently

   For more information about the SCD and mapped roles, see the Slowly Changing Dimensions (SCD) section in the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0