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

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


Explore Informatica Network