Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names MAY change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time.

If the data in the DIMENSION table happen to change very rarely,then it is called as slowly changing dimension.

EX: changing the NAME and address of a PERSON,which happens rerely.

Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names may change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time.

If the data in the Dimension table happen to change very rarely,then it is called as slowly changing dimension.

ex: changing the name and address of a person,which happens rerely.