Description

The Value Mapper maps string values from one value to another. Mapping is usually solved by storing the conversion table in a database. The Value Mapper provides you with a simple alternative.

For example, if you want to replace language codes:

    Fieldname to use: LanguageCode
    Target fieldname: LanguageDesc
    Source/Target: EN/English, FR/French, NL/Dutch, ES/Spanish, DE/German, ...

Note: You can convert a null field or empty String value to a non-empty value. Leave the Source Value field empty. You can specify one of these empty source field values.

Note 2: Null or empty value won't be mapped to the "Default upon non-matching" value. They stay null. Use the above tip if you want to map them anyway.

Options

The following properties are used to define the mappings:

Option	Description
Step name	Name of the step; this name has to be unique in a single transformation.
Fieldname to use	Field to use as the mapping source
Target field name	Field to use as the mapping Target
Default upon non-matching	Defines a default value for situations where the source value is not empty, but there is no match
Field values table	Contains the mapping of source value to converted target value

Metadata Injection Support

All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.