Astera introduces the newest addition to the platform, Astera API Management - a complete API lifecycle management solution. Learn More


ReportMiner, now enabling 10x Faster Template Creation. Further cut down time spent from minutes to seconds! Experience AI Capture


Manage Your Slowly Changing Data with Astera DW Builder

By |2021-09-17T10:25:07+00:00February 23rd, 2021|

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.

How to manage slowly changing dimensions with Astera data warehouse builder

Download the infographic by clicking here.