Time for action – testing the transformation that keeps a historyof 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 ...
Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.