In the preceding section, you loaded a dimension with products by 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 values
N/A for the descriptive fields. Let's make some changes in the operational database, and run the transformation again to see how the Dimension lookup/update step stores history.
update_jumbo_products.sqlscript and run it.
js_dwdatabase again. Right-click on the