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

Row Rules

Row Rules

A row rule analyzes the records in a cluster and selects rows of records that match the rule. You can use multiple rules to filter the records to get a single row of preferred record.
If the row rules return more than one record, the consolidation process uses the user-defined default rules to get a single row of preferred record. If you do not define the default rules, the consolidation process uses the system-defined default rules. If the default rules do not identify a single row of record, the consolidation process skips the cluster.
You can configure a name for each rule and set the rule type and execution order. The consolidation process runs the rules based on the execution order until the consolidation process selects a single row of preferred record.
You can use the following row rules:
  • RANK
  • MODAL_EXACT
  • MOST_FILLED
  • MOST_DATA
  • MAX_COLUMN
  • MIN_COLUMN
  • EQUALS_COLUMN
The following sample lists some row rules:
<RowRules> <RowRule name="rowlevel1" rule="MOST_DATA" order="1" /> <RowRule name="rowlevel3" rule="MOST_FILLED" order="3" /> <RowRule name="rowLevel2" rule="RANK" order="2"> <ReferenceColumn columnName="CITY" /> <Value columnValue="TORONTO" weight="10" /> <Value columnValue="BANGALORE" weight="90" /> </RowRule> <RowRule name="rowLevel5" rule="MAX_COLUMN" order="5"> <ReferenceColumn columnValue="AGE" /> </RowRule> <RowRule name="rowLevel4" rule="EQUALS_COLUMN" order="4"> <ReferenceColumn columnName="AGE">50</ReferenceColumn> </RowRule> <RowRule name="rowlevel7" rule="MODAL_EXACT" order="7" /> <RowRule name="rowLevel6" rule="MIN_COLUMN" order="6"> <ReferenceColumn columnName="AMOUNT" /> </RowRule> <RowRule name="rowLevel8" rule="RANK" order="8"> <ReferenceColumn columnName="LMT_SOURCE_NAME" /> <Value columnValue="Salesforce" weight="10" /> <Value columnValue="ERP" weight="90" /> </RowRule> </RowRules>


Updated November 20, 2019