Time for action – keeping a history of changes in products by using the Dimension lookup/update step

Let's load a puzzles dimension along with the history of the changes in puzzles attributes:

1. Create a new transformation.
2. Drag a Table input step to the work area and double-click on it.
3. As Connection, select js.
4. In the SQL area type the following query:

   SELECT pro_code
        , man_code
        , pro_name
        , pro_theme
   FROM  products
   WHERE pro_type LIKE 'PUZZLE'

5. Click on OK.
6. Add an Add constants step, and create a hop from the Table input step toward it.
7. Use the step to add a Date field named changedate. As format, type dd/MM/yyyy and as value, type 01/10/2009.
8. Expand the Data Warehouse category of steps.
9. Select the Dimension lookup/update step and drag it to the canvas.
10. Create a hop from the Add constants step to this new step.
11. Double-click on the Dimension lookup/update step.
12. As Connection, select dw.
13. As Target table, type lk_puzzles.
14. Fill the Key fields, as shown in the following...