Installation and Configuration Guide

10.1 HotFix 1
- 10.1

Back Next

Column Rules

A column rule analyzes a column in the cluster and selects the column values that match the rule. If the rule returns more than one column value, the consolidation process uses the user-defined default rules to get a single preferred column value. If you do not define the default rules, the consolidation process uses the system-defined default rules. If the default rules return more than one preferred column value, the consolidation process skips the cluster.

The preferred column value replaces the corresponding column value in the preferred record that the row rules return. You can configure a column rule for a single column or a group of columns with a name and the rule type.

You can use the following column rules:

RANK

MOST_DATA

MODAL_EXACT

MAX_COLUMN

MIN_COLUMN

FROM_MASTER

EQUALS_OTHER_COLUMN

MIN_OTHER_COLUMN

MAX_OTHER_COLUMN

The following sample uses the column rules:

<ColumnRules>
   <ColumnGroup name="COL_GROUP1" rule="MOST_DATA">
      <ColumnRule columnName="NAME" />
      <ColumnRule columnName="CITY" />
   </ColumnGroup>
   <ColumnRule name="OTHERMAX_RULE1" rule="MAX_OTHER_COLUMN" columnName="OTHERCOLM">
      <ReferenceColumn columnName="AMOUNT" />
   </ColumnRule>
   <ColumnRule name="OTHERMIN_RULE1" rule="MIN_OTHER_COLUMN" columnName="OTHERCOLMIN">
      <ReferenceColumn columnName="AGE" />
   </ColumnRule>
   <ColumnRule name="OTHEREQ_RULE1" rule="EQUALS_OTHER_COLUMN" columnName="OTHERCOLEQ">
      <ReferenceColumn columnName="ADDRESS">BANGALORE</ReferenceColumn>
   </ColumnRule>
   <ColumnRule name="AMOUNT_RULE1" rule="MIN_COLUMN" columnName="AMOUNT" />
   <ColumnRule name="SOURCE_RULE" rule="FROM_MASTER" columnName="LMT_SOURCE_NAME" />
   <ColumnRule name="CITY_RULE" rule="RANK" columnName="CITY">
      <Value columnValue="TORONTO" weight="10" />
      <Value columnValue="BANGALORE" weight="90" />
   </ColumnRule>
   <ColumnRule name="AGE_RULE" rule="MOST_DATA" columnName="AGE" />
   <ColumnRule name="AGE_RULE1" rule="MAX_COLUMN" columnName="AGE" />
   <ColumnRule name="NAME_RULE" rule="MODAL_EXACT" columnName="NAME" />
</ColumnRules>

Creating a Consolidation Rules File