Processing Cost—Very High
Process Cost Explanation—Conditional mapping process returns recordsets with all dimension fields to the application server; results in high amount of data transfer and memory utilization
Server Resources Used—Application server
Recommendation—Restrict conditional ranges. Rather than using one large range (0000 to 9999), divide the range into multiple, smaller rule blocks (0000 to 1000, 1001 to 2000, for example); optimizes memory utilization
Restrictions—Source values in range must be same number of characters
Good Example—Between xxxx,yyyy —> #Script
Poor Example—Between xxxx,yyyyyy —> #Script