The data warehouse is built to deliver insights on your business’s activities based on current and historical data. This trusted view is based on data from a variety of source systems. During the development process, ETL processes are put in place to locate and extract relevant data from these sources. Inputs are then cleansed, validated, and standardized before being loaded into the EDW.
The result? A consolidated architecture that offers accurate and timely intelligence on many of your key operations and functions.
But of course, enterprise data is dynamic. The data you use to inform your decisions today may well change 6 months from now. Think about how often you see employee designations change or how product lines are often updated or relaunched under a different name. The question is, how can your EDW account for these ongoing changes.
The answer lies in dimensional modelling technique known as slowly changing dimensions (SCD). By applying SCD to your data warehouse dimension tables, you can easily manage and track changing data in your EDW by either updating, modifying, or adding to existing records. In ADWB, we allow you to implement SCD types at the metadata level using our data model designer. We support multiple SCD-handling techniques, including SCD Type 1, Type 2, Type 3, and Type 6.
Check out the infographic below to find out how you can apply these techniques in different business scenarios to best suit your reporting requirements.