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

MOST_FILLED

MOST_FILLED

The MOST_FILLED rule selects the row that has the highest number of non-blank columns.
The following table displays a sample cluster and indicates the preferred record for the cluster based on the MOST_FILLED rule:
Cluster ID Employee Name City Age Department Comment
1 John Smith 31 Sales
1 J Smith New York 30 Human Resources Row-level preferred record
1 John Jr Smith Seattle Support
The MOST_FILLED rule selects the second row as the preferred record because it contains values in four columns.
Use the following format to configure a MOST_FILLED rule:
<RowRules>   
   <RowRule name="<Rule name>" rule="MOST_FILLED" order="<Execution order>"/>
</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.
The following sample includes the MOST_FILLED rule:
<RowRules>
   <RowRule name="rowlevel3" rule="MOST_FILLED" order="1" />
</RowRules>


Updated June 27, 2019


Explore Informatica Network