DecisionStream's handling of slowly changing dimensions is automatic, based on definitions in the dimension template library, using automatically generated surrogate keys.

In this example, an employee has changed branches, moving from the Boston office to the Philadelphia office. Because SalesBranchCode is defined as a Type II slowly changing dimension attribute, whenever the build for this dimension is executed, DecisionStream automatically handles the record insertion to manage the change. The new record includes an updated surrogate value, as well as appropriate start and end dates.

DecisionStream handles both Type I and Type II slowly changing dimensions with a "point and click" interface, and no coding requirements.