Slowly changing Dimensions

The Slowly Changing Dimension transformation coordinates the updating and inserting of records in data warehouse dimension tables. The Slowly Changing Dimension transformation provides the following functionality for managing slowly changing dimensions:

1. Matching incoming rows with rows in the lookup table to identify new and existing rows.
2. Identifying incoming rows that contain changes when changes are not permitted.
3. Identifying inferred member records that require updating.
4. Identifying incoming rows that contain historical changes that require insertion of new records and the updating of expired records.
5. Detecting incoming rows that contain changes that require the updating of existing records, including expired ones.

Output Types:

• Type 0: Fixed Attribute Output
• Type1: Changing Attributes Updates Output
• Type2 : Historical Attributes Inserts Output
• Type3: Create new column for every updation.
• More on New output, Unchanged Output and Inferred Member Updates Output

Type 0 : It do not allows to update any record inside dimension

Type 1 : It just update each record there is no trace for old record

Type 2 : It add new record in dimension table for each update. It uses flag value or time-stamp to check new value

Type 3 : It creates new column for each updation. This type is not preferable for record which updates more than two times.