Table of Contents

Search

  1. Preface
  2. Installing Informatica MDM - Relate 360
  3. Configuring Relate 360
  4. Configuring Security
  5. Setting Up the Environment to Process Streaming Data
  6. Configuring Distributed Search
  7. Packaging and Deploying the RESTful Web Services
  8. Troubleshooting

Installation and Configuration Guide

Installation and Configuration Guide

MIN_OTHER_COLUMN

MIN_OTHER_COLUMN

The MIN_OTHER_COLUMN rule selects the column value from a record that contains the lowest value of the specified column. The MIN_OTHER_COLUMN rule uses case-insensitive lexicographical ordering to find the lowest value.
For example, use the City value from a record that contains the lowest age.
The following table displays a sample cluster and indicates the rule-level preferred record:
Cluster ID Employee Name City Age Department Comment
1 John Smith San Francisco 31 Sales Row-level preferred record
1 J Smith Redwood City 32 Human Resources
1 John Jr Smith Seattle 30 Support
The following table lists the preferred record with the preferred column value based on the MIN_OTHER_COLUMN rule applied on the City column:
Cluster ID Employee Name City Age Department Comment
1 John Smith Seattle 31 Sales Column-level preferred record
Seattle is the preferred column value because it is part of the row that contains the lowest age.
Use the following format to configure a MIN_OTHER_COLUMN rule:
<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MIN_OTHER_COLUMN" columnName="<Primary column name">
      <ReferenceColumn columnName="<Reference column name>" />
   </ColumnRule>   
</ColumnRules>
The format uses the following parameters:
Rule name
Unique name for the rule.
Primary column name
Name of the column based on which you want to configure the rule.
Reference column name
Name of the column in which you want to find the lowest value. The consolidation process identifies the record that contains the lowest column value and then uses the primary column value from the selected record as the preferred column value.
The following sample MIN_OTHER_COLUMN rule indicates to use the City value from a record that contains the lowest age:
<ColumnRules>
   <ColumnRule name="OTHEREQ_RULE1" rule="MIN_OTHER_COLUMN" columnName="City">
      <ReferenceColumn columnName="Age" />
   </ColumnRule>
</ColumnRules>


Updated June 27, 2019


Explore Informatica Network