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

System-Defined Default Rules

System-Defined Default Rules

The consolidation process uses the system-defined default rules only when you do not define any default rule in the consolidation rules file. The system-defined default rules identify a single preferred record when the row rules return multiple records or a single preferred column value when a column rule returns multiple values.
The system-defined default rules uses the following rules:
  1. Recent time stamp of the record. The consolidation process skips the rule when you persist the consolidated data in HDFS or when you run the consolidation job in the initial mode.
  2. Highest value of the combined primary key and source column values. The consolidation process uses case-insensitive lexicographical ordering to find the highest value.
For example, if a column rule returns multiple values and you do not define any default rules, the consolidation process uses the system-defined default rules. The rules identify the record that has the recent time stamp and then select the corresponding column value as the preferred column value. If you have multiple records with the same time stamp, the rules combine the primary key and source column values of each record and select the record that has the highest value. The rules then return the corresponding column value as the preferred column value.

0 COMMENTS

We’d like to hear from you!