Benefits of partitioning

Using the previous example, explore the benefits of partitioning.

  • The rule is shorter than the rule without partitioning. The knowledge of which states belong to each region is maintained in the schema rather than the map rule.
  • It is easy to read this map rule and understand the mapping function being performed. For example, if the state belongs to the list of states in the eastern region, execute the MapEast functional map.
  • The partitioning method is easier to maintain. If a value for State is added or moves from one region to another, it can be easily changed in the schema and automatically reflected in any mapping rules that reference the partitioned object.
  • Partitioning using a restriction list used with the Ignore Case setting eliminates the need for PROPER, LOWERCASE, or UPPERCASE functions to compare each state with a literal.