Pentaho 3.2 Data Integration Beginner's Guide

Time for action—testing the transformation that keeps a history of product changes

1. In the previous tutorial you loaded a dimension with products by using a Dimension lookup/update step. You ran the transformation once, causing the insertion of one record for each product and a special record with values n/a for the descriptive fields. Let's apply some changes in the operational database, and run the transformation again to see how the Dimension lookup/update step keeps history.
2. In MySQL Query Browser, open the script update_jumbo_products.sql and run it.
3. Switch to Spoon.
4. If the transformation created in the last tutorial is not open, open it again.
5. Run the transformation. Explore the js_dw database again. Press Open SQL for [lk_puzzles] and type the ...