Time for action—testing the transformation that keeps a history of product changes
- 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.
- In MySQL Query Browser, open the script
update_jumbo_products.sql and run it.
- Switch to Spoon.
- If the transformation created in the last tutorial is not open, open it again.
- 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.