Using Special Characters in Multi-Dimensional Mapping

The Source and Target Value expressions can use special characters. These characters (typically ? and *) can be prefixed or suffixed by one or more characters, which filters the source value by that prefix or suffix.

Special characters include:

• Asterisk (*)—An asterisk (*) represents the source value. The asterisk (*) can be prefixed or suffixed by one or more characters, which filters the source value by that prefix or suffix. The wild card or strips (data load to write back) takes whatever is present in the source and puts it in the target column, usually adding a prefix. An asterisk (*) represents the source value. The asterisk (*) can be prefixed or suffixed by one or more characters, which filters the source value by that prefix or suffix. The wild card takes whatever is present in the source and puts it in the target column, usually adding a prefix.
• Question Mark (?)—The question mark (?) strips a single character from the source value. You can use one or more question marks (?) in the expression. You can also use question marks in combination with other expressions. For example: A?? finds members that start with A and have any two characters following and selects the members or strips off the two characters.

For multiple dimensions, the source dimension is the value brought over and the wild card applies to it alone. The dimensions can be present in a multiple dimensional rule and use wild cards. The prefix/suffix applies only to the source, which equals the target dimension (the dimension on which the rule resides).