In the case of a Type II SCD, you use the same step that you used to load the table dimension—a Dimension L/U step. The difference is that here you unchecked the Update the dimension? option. By doing that, the step behaves quite as a database lookup—you provide the keys to look up and the step returns the fields you put in both the Fields tab and the Technical key field option. The difference with this step is that here you have to provide time information. Using this time information, PDI finds and returns the proper record in time from the Type II SCD.
The following image shows you how to configure the step for the sample PUZZLES dimension:
Obtaining the surrogate key for a Type II SCD
Here, ...
