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

MODAL_EXACT

MODAL_EXACT

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


Updated November 20, 2019