When using Oracle RAC, Between map rules that include non-numeric characters in the rule definition must use conditional mapping. The following example shows that rule w2426 contains “2426, 2435-2812” in the rule definition field. The hyphen is non-numeric, therefore, this rule is made conditional by entering #script in the Target Account field and result=”<target account” in the Script field.
If you are upgrading from an older version of FDM, or have recently enabled RAC in Oracle and are using existing maps, then you must update any “Between” mapping rules that contain nonnumeric characters in the rule definition. In this example, rules w4440, and w4460 through w4901 must be updated to be conditional mappings.