I'm new on this forum but i'm a Kettle fan.
I am working on a Data Warehouse project here in Brazil, and using the step "Combination lookup-update" to load some dimension tables.
Then i figured out that I could use this step to lookup the surrogate key of a dim table and bring it to a fact table, or even get the key of a "demography dim table" and bring the key to a "person dim table". But, i did not found how to use the "Lookup Functionality" of this step. (This functionality is present on the step "Dimension Lookup-Update" unchecking the check-box named "Update the dimension?")
I just could not find the check-box that give this functionality to the step. And the more strange is that this check-box is present on the wiki page of this step on the link:http://wiki.pentaho.com/display/EAI/...+lookup-update
I tried to find this check-box, with any success, on the following kettle versions: 3.0.4, 3.2.0 and 4.0.0, all GA versions.
Could someone help me on that?
Thanks already, and sorry if my english is not the best