Turning Off Slowly Changing Dimensions
If you turn off the slowly changing dimensions (SCDs) for a field, the current dimensional row can be updated with a new value without the addition of a new dimensional row.
Slowly changing dimensions can be controlled on a field-by-field level. If slowly changing dimensions are turned on, a change will cause a new row to be added. If slowly changing dimensions is turned off, a new row will not be added if a change is made to that field. For example, if the Activity Description field has slowly changing dimensions turned on, then changes made to this field will cause a new row to be added to the dimensional table the next time the STARETL process is run. If the EPS Name field has slowly changing dimensions turned off, then the STARETL process will not update the dimensional table with a new row. Have these settings configured for each field can prevent cascading updates to fact tables. For example, if a change is made to the EPS table, that change would cause a new row to be added to the dimension table for all of the activities affected by the change.
Submit a Service Request on My Oracle Support if you want to:
- Enable or disable slowly changing dimensions for a field or
- Delete SCD data for an effective date or a specific date range
Last Published Friday, July 5, 2024