Type-2 Slowly Changing Dimension (SCD) Implementation in Oracle Cloud Infrastructure (OCI) Data Integration
Blog: Oracle BPM
A Type-2 Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. When the value of chosen attributes of record changes,record is made inactive and a new record is created with modified data as active record. Type-2 SCD is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records.
Leave a Comment
You must be logged in to post a comment.