In the preceding section, you loaded a dimension with products using a Dimension lookup/update step. You ran the Transformation once, caused the insertion of one record for each product, and a special record with N/A values for the descriptive fields. In order to effectively see how history is kept, we will make some changes in the operational database and run the Transformation again to see how the Dimension lookup/update step stores history:
- Among the downloaded material, locate the update_jumbo_products.sql script and run it. This script will change the category to a list of products.
- Switch to Spoon.
- Open the Transformation created in the last tutorial and run it.
- Explore the