Learning Pentaho Data Integration 8 CE - Third Edition

Explaining and loading Type III SCD and Hybrid SCD

In the preceding example, in which you loaded a Type II SCD, you filled the Type of dimension update column with the Insert option for every field. By doing this, you loaded a pure Type II dimension, that is, a dimension that keeps track of all changes in all fields. In the sample puzzles dimension, you kept history of changes both in the theme and name fields. If you want to track sales by theme, keeping a Type II SCD is the option you should choose. On the other hand, if the name of the puzzle changes, you may not be interested in the previous name. Fortunately, you are not forced to keep track of every change in your dimension. In a situation like this, you may change the configuration ...