English
MDM - Relate 360 All Products

Table of Contents

Search

  1. Preface
  2. Installing MDM Big Data Relationship Management
  3. Configuring MDM Big Data Relationship Management
  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

Back Next

Configuring a Column Rule for a Group of Columns

Configuring a Column Rule for a Group of Columns

You can configure a column rule for a group of columns. The consolidation process identifies the preferred column value for each column based on the rule and updates the corresponding column value in the preferred record that the row rules return.
Use the following format to configure a column rule for a group of columns: 
<ColumnRules>
   <ColumnGroup name="<Unique name>" rule="<Column rule name>">
      <ColumnRule columnName="<Column name 1>" />
      <ColumnRule columnName="<Column name 2>" />
      ...
      <ColumnRule columnName="<Column name N>" />
   </ColumnGroup>
</ColumnRules>
The format uses the following parameters:
Unique name
Unique name for the rule.
Column rule name
Name of the column rule that you want to use.
You can use the following column rules:
  • RANK
  • MOST_DATA
  • MODAL_EXACT
  • MAX_COLUMN
  • MIN_COLUMN
  • FROM_MASTER
  • EQUALS_OTHER_COLUMN
  • MIN_OTHER_COLUMN
  • MAX_OTHER_COLUMN
Column name 1, 2,...N
Name of the columns for which you want to configure the rule.
The following sample MAX_COLUMN rule is configured for the NAME and CITY columns: 
<ColumnRules>
   <ColumnGroup name="COL_GROUP1" rule="RANK">
      <ColumnRule columnName="NAME" />
      <ColumnRule columnName="CITY" />
   </ColumnGroup>
</ColumnRules>

Updated June 27, 2019

Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal