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

MODAL_EXACT

MODAL_EXACT

The MODAL_EXACT rule selects a column value that has the highest count of the most frequent non-blank values.
The following table displays a sample cluster and indicates the row-level preferred record:
Cluster ID Employee Name City Age Department Comment
1 John Smith New York 31 Sales Row-level preferred record
1 J Smith Seattle 31 Human Resources
1 John Smith Seattle 30 Sales
The following table lists the preferred record with the preferred column value based on the MODAL_EXACT rule applied on the City column:
Cluster ID Employee Name City Age Department Comment
1 John Smith Seattle 31 Sales Column-level preferred record
Seattle is the preferred column value because it has the highest count of the most frequent value.
Use the following format to configure a MODAL_EXACT rule:
<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MODAL_EXACT" 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 MODAL_EXACT rule is based on the City column:
<ColumnRules>
   <ColumnRule name="NAME_RULE" rule="MODAL_EXACT" columnName="City"></ColumnRule>
</ColumnRules>


Updated June 27, 2019


Explore Informatica Network