How ETL Tools Perform value mapping (similar to the CAS when feature of Oracle)

Source: Internet
Author: User
Tags cas
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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.