Configure Type 2 SCDs (Optional)
Last updated
Last updated
In the final step, you can configure the visual to support Type 2 Slowly Changing Dimensions.
Type 2 Slowly Changing Dimension (SCD) is a data warehousing method to track changes in data over time by preserving the change history.
-> When a value in a dimension (such as customer information) changes, a new record is created instead of overwriting the old data.
-> Each new record includes the updated information along with the start and end dates indicating the validity period of the updated information.
-> There can be an additional flag column that indicates the record is currently active. This column can be of the checkbox type, or a simple true/false or 0/1 column.
-> There can also be additional timestamp columns to signify when a new record was created or made active apart from the initial start date.
This approach allows us to analyse the historical data and understand how the information has evolved over time.
For more details on SCDs and their types, click here.
We will now look at the overview:
To configure SCDs, click on the link as shown in the image below:
Enable support for SCDs and configure them.
We have a detailed section that explains how to configure type 2 SCDs in EDITable and you can access it here.
If you do not wish to enable support for Type 2 SCDs, simply click Save without enabling the toggle button as below.
The action of configuring SCDs is permanent and cannot be undone once enabled and saved.
If you have missed configuring SCDs and wish to set it on a later date or you need to edit the existing configuration, you will need to reset all the visual settings by clicking on Reset in the Settings window. Note that this resets all the settings, including the source and column configurations.
After configuring all the required settings, you can close the 'Settings' tab by clicking Close Settings or by directly navigating to the Home tab. EDITable displays the connected source table as below:
After configuring the source data, you are good to go with managing and updating your data with EDITable.
