1. User Guide
  2. Dimension Population
  3. Dimension Table Population
  4. SCD Process Scenarios

4.3.6 SCD Process Scenarios

It is not necessary to run SCD for all dimensions. In certain cases, you should specify the specific dimension requiring updates.

The following common scenarios provide guidance on which dimensions must be rerun:

  • Rerunning an existing ALM Process for the same as-of-date. It is not necessary to rerun any of the SCD dimensions.
  • Running an existing ALM Process for a new as-of-date.
  • Run SCD for Time Dimension (3), to refresh DIM_RESULT_BUCKET. Once per as-of-date and applies to all ALM processes run for that As-of-Date.
  • Running a new ALM Process:
    1. Run SCD for Forecast Rate Scenarios or Stochastic Process (1)
    2. If new as-of-date, also run for Time Dimension (3)

      If Hierarchy changes are made, rerun SCD for the appropriate dimension(s). For example, 4-7 as needed