Dimension Tables Population

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:

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/E18283_01/owb.112/e10935/toc.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

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