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