Processing Cost—Very High
Process Cost Explanation—Conditional mapping process returns recordsets with all dimension 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 application 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* —> #Script
Poor Example—Like * —> #Script