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

https://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf

·       Oracle® Warehouse Builder Data Modeling, ETL, and Data Quality Guide at

https://docs.oracle.com/cd/E11882_01/owb.112/e10935.pdf

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

·       http://www.oraclebidwh.com/2008/11/slowly-changing-dimension-scd/

·       http://www.informationweek.com/news/software/bi/showArticle.jhtml?articleID=204800027&pgno=1

·       http://www.informationweek.com/news/software/bi/showArticle.jhtml?articleID=59301280

·       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.