Configure Type 2 SCDs (Optional)

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.

Understanding Type 2 SCDs

-> 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:

  1. To configure SCDs, click on the link as shown in the image below:

Review optional settings - Configure SCDs
  1. Enable support for SCDs and configure them.

Configure SCDs

We have a detailed section that explains how to configure type 2 SCDs in EDITable and you can access it here.

  1. If you do not wish to enable support for Type 2 SCDs, simply click Save without enabling the toggle button as below.

Save without enabling SCDs
  1. 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:

Source

After configuring the source data, you are good to go with managing and updating your data with EDITable. You can jump to this section to know more.

EDITable also supports creating a table from scratch or importing it from spreadsheets. These steps are explained in the next section.

Last updated