6 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

  <http://www.oracle.com/technetwork/middleware/data-integrator/overview/odi-bestpractices-datawarehouse-whi-129686.pdf >

• Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide at

  <http://download.oracle.com/docs/cd/E16338_01/owb.112/e10935/dim_objects.htm>

Additional online sources include:

<http://en.wikipedia.org/wiki/Slowly_changing_dimension>

<http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/owb/owb10gr2_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>

You can also refer to 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 OFSAA BI applications installers are Type 1 and Type 2.