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 ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.