Table of Contents

Search

  1. Preface
  2. Installing MDM Big Data Relationship Management
  3. Configuring MDM Big Data Relationship Management
  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

MIN_COLUMN

MIN_COLUMN

The MIN_COLUMN rule selects the row that contains the lowest value in the specified column. The MIN_COLUMN rule uses case-insensitive lexicographical ordering to find the lowest value.
The following table displays a sample cluster and indicates the preferred record for the cluster based on the donation amount:
Cluster ID Employee Name City Donation Amount Department Comment
1 John Smith San Francisco 800 Sales
1 J Smith Redwood City 1000 Human Resources Row-level preferred record
1 John Jr Smith Seattle 900 Support
The MIN_COLUMN rule selects the second row as the preferred record because 1000 is the lowest donation amount based on the lexicographical ordering.
Use the following format to configure a MIN_COLUMN rule:
<RowRules>   
   <RowRule name="<Rule name>" rule="MIN_COLUMN" order="<Execution order>">
      <ReferenceColumn columnName="<Column name>" />      
   </RowRule>   
</RowRules>
The format uses the following parameters:
Rule name
Unique name for the rule.
Execution order
Optional. Order of execution for the rule. Use an integer value for the order of execution. If you do not specify the execution order, the consolidation process runs the rule based on the sequence of rules listed in the consolidation rules file. If you specify the execution order for a rule, you must specify the execution order for other rules.
Column name
Name of the column based on which you want to configure the rule.
The following sample MIN_COLUMN rule is configured for the Donation Amount column:
<RowRules>   
   <RowRule name="rowLevel5" rule="MIN_COLUMN" order="1">
      <ReferenceColumn columnName="Donation Amount" />
   </RowRule>
</RowRules>


Updated June 27, 2019


Explore Informatica Network