Configure SCDs (Optional)
In the final step, you will have the option to configure the visual to support Type 2 Slowly Changing Dimensions.
Type 2 Slowly Changing Dimension (SCD) is a method used in data warehousing to track changes in data over time without losing its history.
When a value in a dimension (like customer information) changes, instead of overwriting the old data, a new record is created.
Each new record contains the updated information and includes start and end dates to show the duration when each record was valid.
This method allows you to analyze historical data and understand how things have evolved over time.
For more details on Type 2 SCDs, click here.
To learn how to configure the fields for SCDs in detail, refer to here.
To configure SCDs, click on the link as shown in the image below:
Enable support for SCDs and configure them.
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.
Last updated