Dimensional data changes are handled by the OFS EFPA application using the SCD component.
SCDs are dimensions that have data that changes slowly, rather than changing on a time-based, regular schedule.
For more information on SCDs, see the following sources:
· Oracle Data Integrator Best Practices for a Data Warehouse at:
· Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide at:
https://docs.oracle.com/cd/E18283_01/owb.112/e10935/toc.htm
· Additional online sources include:
http://en.wikipedia.org/wiki/Slowly_changing_dimension
· 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 OFS EFPA application are Type 1 and Type 2.