# 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**](https://en.wikipedia.org/wiki/Slowly_changing_dimension)**.**

We will now look at the overview:

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

<figure><img src="/files/Kzo6r6xlLk3Muto9biNU" alt=""><figcaption><p>Review optional settings - Configure SCDs</p></figcaption></figure>

2. Enable support for SCDs and configure them.

<figure><img src="/files/GAXRpjhCRvlX7rTHW7tJ" alt=""><figcaption><p>Configure SCDs</p></figcaption></figure>

{% hint style="info" %}
**We have a detailed section that explains how to configure type 2 SCDs in EDITable and you can access it** [**here**](/editable/type-2-scds/configuring-type-2-scds-in-editable.md)**.**
{% endhint %}

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

<figure><img src="/files/ly9h6i9nMcmS45C7YzUA" alt=""><figcaption><p>Save without enabling SCDs</p></figcaption></figure>

{% hint style="warning" %}

1. The action of configuring SCDs is permanent and cannot be undone once enabled and saved.

2. 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.
   {% endhint %}

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

<figure><img src="/files/HmsZeRAQq030NWSjxJjJ" alt=""><figcaption><p>Source</p></figcaption></figure>

After configuring the source data, you are good to go with managing and updating your data with EDITable. You can jump to [this section](/editable/working-with-editable.md) to know more.

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/editable/getting-data-into-editable/connect-to-data/configuration-steps/configure-type-2-scds-optional.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.