Dictionary Term

Slowly Changing Dimensions


Slowly Changing Dimensions (SCDs) describe a process by which data in dimensions changes infrequently, over the course of long periods of time. Because SCDs can compromise the integrity of a dimension, a number of strategies have been developed to handle them, such as deleting old data and replacing it with new data, keeping all data intact in the same table or creating separate tables to divide old data from new data.

Sources :

Further reading: http://support.sas.com/documentation/cdl/en/etlug/63360/HTML/default/viewer.htm#p135va247x8srjn1gu7wzjc7cps9.htm http://www.1keydata.com/datawarehousing/slowly-changing-dimensions.html http://en.wikipedia.org/wiki/Slowly_Changing_Dimensions

Back to Dictionary