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