4.2 Overview of SCD Process
SCDs are dimensions that have data that changes slowly, rather than changing on a time-based, regular schedule.
For more information on SCDs, see
- Oracle Data Integrator Best Practices for a Data Warehouse at:
- Oracle® Warehouse Builder Data Modeling, ETL, and Data Quality Guide at:
Additional online sources include:
- http://en.wikipedia.org/wiki/Slowly_changing_dimension
- http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/owb/owb10 gr2_gs/owb/lesson3/slowlychangingdimensions.htm
- An excellent published resource that covers SCD in detail is The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball and Margy Ross.
The SCD component of the platform is delivered via a C++ executable. The types of SCD handled by the OFSAAI SCD component for OFSPA solution are Type 1 and Type 2.