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

RANK

RANK

The RANK rule selects a column value based on the specified column value that has the highest weight.
For example, set the weight for the Human Resources department to 90 and the weight for the Sales department to 10.
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 30 Human Resources
1 John Jr Smith Seattle Support
The following table lists the preferred record with the preferred column value for the cluster based on the RANK rule:
Cluster ID Employee Name City Age Department Comment
1 John Smith New York 31 Human Resources Preferred record
Human Resources is the preferred column value because it has the highest weight.
Use the following format to configure a RANK rule:
<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="RANK" columnName="<Column name">
      <Value columnValue="<Column value 1>" weight="<Weight 1>" />
      <Value columnValue="<Column value 2>" weight="<Weight 2>" />
      ...
      <Value columnValue="<Column value N>" weight="<Weight N>" />
   </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.
Column values 1, 2,...N
Column values for which you want to set the weight.
Weight 1, 2,...N
Weight for the corresponding column value. The consolidation process identifies the preferred column value based on the weight of the column values.
The following sample RULE rule sets the weight for the Human Resources department to 90 and the weight for the Sales department to 10:
<ColumnRules>
   <ColumnRule name="DepartmentRule" rule="RANK" columnName="Department">
      <Value columnValue="Human Resources" weight="90" />
      <Value columnValue="Sales" weight="10" />
   </ColumnRule>   
</ColumnRules>


Updated June 27, 2019


Explore Informatica Network