Map Like (two-sided source values used to derive target values)

Processing Cost— High

Process Cost Explanation—Target value derivation process returns recordsets with the specified dimension's fields to the app server; results in high amount of data transfer and memory utilization

Server Resources Used— Application server

Recommendation— Restrict Like criteria. Don’t use a * without other criteria in the rule definition, which causes a large volume of records to be written to the app server. Use criteria such as 1*, 2*, 3* or A*, B*, C*, for example, to limit each query to a subset of what you need to map; optimizes memory utilization

Restrictions—None

Good Example—Like 12* —> Target*

Poor Example—Like * —> Target*