A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Different SCD strategies could be implemented and this tips and tricks is focused on SCD1 where records are updated no history is kept and SCD2 where history is kept,
In this tips and tricks we will first create a dataset and fresh series of records to update it. We will see how we can add those new records in SAS using Proc Append and set statement. Then we will see how we can update existing records with new records using merge and update statement. Then we will see how we can detect new records and records to update trough the Data Step. When those building blocks will have been created we will start the SCD methodology sensu stricto:
You have some SAS experience and have knowledge in Datawarehouse. You want to update existing tables using SCD method.
click here to get more information about this teacher.
This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles