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

Installation and Configuration Guide

Installation and Configuration Guide

MAX_COLUMN

MAX_COLUMN

The MAX_COLUMN rule selects the highest column value. The MAX_COLUMN rule uses case-insensitive lexicographical ordering to find the highest value.
The following table displays a sample cluster and indicates the row-level preferred record:
Cluster ID Employee Name City Donation Amount Department Comment
1 John Smith San Francisco 1000 Sales
1 J Smith Redwood City 800 Human Resources
1 John Jr Smith Seattle 900 Support Row-level preferred record
The following table lists the preferred record with the preferred column value based on the MAX_COLUMN rule applied on the Donation Amount column:
Cluster ID Employee Name City Donation Amount Department Comment
1 John Jr Smith Seattle 900 Support Column-level preferred record
The MAX_COLUMN rule selects 900 as the preferred column value because it is the highest donation amount based on the lexicographical ordering.
Use the following format to configure a MAX_COLUMN rule:
<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MAX_COLUMN" columnName="<Column name">
   </ColumnRule>   
</ColumnRules>
The format uses the following parameters:
Rule name
Unique name for the rule.
Column name
Name of the column based on which you want to configure the rule.
The following sample MAX_COLUMN rule is based on the Donation Amount column:
<ColumnRules>
   <ColumnRule name="NAME_RULE" rule="MAX_COLUMN" columnName="Donation Amount"></ColumnRule>
</ColumnRules>


Updated June 27, 2019