The value mapping here is a bit like the Oracle's CAS when feature, such as a field a value of 1, but I now want to make the a=1 of a male, that is, 1 mapping into a male, this is the value mapping, then how to operate, in fact, Kettle has a "value mapping" component The following is a brief introduction to how to use;
First enter the value mapping in the search box to the left of the program, find the value mapping component, and then drag to the desired location, and then double-click the point to open, first you can set a step name, do not want to set the default line, the next choice to use the field name, which must be selected, and then see "Default when Mismatched" And then the source value, the source value is the original value, the target value is the corresponding value;
How ETL Tools Perform value mapping (similar to the CAS when feature of Oracle)