Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • MDM Registry Edition 10.1 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. Cluster Merge Rules
  13. Forced Link and Unlink
  14. System Backup and Restore
  15. Batch Utilities

Operations Guide

Operations Guide

Back Next

Column Rules

Column Rules

This section provides information on the options of Column Rules.
  • from master
    Selects the value from the master record.
  • modal exact
    Selects the records that contain the modal (most common) value. The modal value is determined by a strict comparison.
sdf snippet 

merge-definition
*===============
NAME= 							person-merge-modal
MASTER-SELECTION= 			modal-exact
COLUMN-SELECTION= 			Name, Addr, Updated
*
merge-master-definition
*======================
NAME= modal-exact
TYPE= modal-exact
*
merge-column-definition
*===============
NAME= Name
IDTCOLUMN= Name
RULE-SELECTION= from-master
*
merge-column-definition
*===============
NAME= Addr
IDTCOLUMN= Addr
RULE-SELECTION= from-master
*
merge-column-definition
*===============
NAME= Updated
IDTCOLUMN= Updated
RULE-SELECTION= from-master
*
merge-column-rule-definition
*===========================
NAME= from-master
TYPE= from-master
*
Input
Result 

Name Addr updated
John Smith 12 Maine Street 14072008
John Smith 12 Main Street 13072008
Jon Smith 12 Main Street 23082008
John Smith 12 Main Street 13072008

most-data

  • most-data
    Selects the records with the most data (longest sum of string lengths).
sdf snippet 

merge-definition
*===============
NAME= 														person-merge
MASTER-SELECTION= 		modal-exact
COLUMN-SELECTION= 		name-most-data
*
merge-column-definition
*===============
NAME= name-most-data
IDTCOLUMN= name
RULE-SELECTION= most-data
*
merge-column-rule-definition
*===========================
NAME= most-data
TYPE= most-data
*
Input
Result 

name
John Smith
John J Smith
John Smyth
John J Smith

min

  • min
    Selects the records with the lowest value in the current column.
sdf snippet 

merge-definition
*===============
NAME= person-merge-min-salary
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= salary-min
*
merge-column-definition
*===============
NAME= salary-min
IDTCOLUMN= salary
RULE-SELECTION= min
*
merge-column-rule-definition
*===========================
NAME= min
TYPE= min
*
Input
Result 

salary
0100000
0065000
0080000
0066000
0065000

max

  • max
    Selects the records with the highest value in the current column.
sdf snippet 

merge-definition
*===============
NAME= person-merge-max-date
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= date-max
*
merge-column-definition
*===============
NAME= date-max
IDTCOLUMN= date
FORMAT= "MDY"
RULE-SELECTION= max
*
merge-column-rule-definition
*===========================
NAME= max
TYPE= max
*
Input
Result 

date
01302004
01322005
04301999
01012005
07221997
01322005

sum

  • sum
    Selects a generated record with the sum of all values in the current column.
sdf snippet 

merge-definition
*===============
NAME= person-merge
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= salary-sum
*
merge-column-definition
*===============
NAME= salary-sum
IDTCOLUMN= salary
RULE-SELECTION= sum
*
merge-column-rule-definition
*===========================
NAME= sum
TYPE= sum
*
Input
Result 

salary
0100000
0065000
0080150
0066999
0312149

mean

  • mean
    Selects a generated record with the average of all values in the current column.
sdf snippet 

merge-definition
*===============
NAME= 													person-merge
MASTER-SELECTION= 	modal-exact
COLUMN-SELECTION= 	salary-sum
*
merge-column-definition
*===============
NAME= salary-sum
IDTCOLUMN= salary
RULE-SELECTION= sum
*
merge-column-rule-definition
*===========================
NAME= sum
TYPE= sum
**
Input
Result 

salary
0100000
0064000
0080000
0072400
0079100

other column equals

  • other column equals
    Selects the records where a different column equals a value. The TARGET-COLUMN and VALUE parameters must be provided.
sdf snippet 

merge-definition
*===============
NAME= person-merge
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= salary-where-verified
*
merge-column-definition
*===============
NAME= salary-where-verified
IDTCOLUMN= salary
RULE-SELECTION= verified
*
merge-column-rule-definition
*===========================
NAME= verified
TYPE= other-column-equals
TARGET-COLUMN= verified
VALUE= Y
*
Input
Result 

salary verified
0100000 N
0064000 Y
0080000 N
0072400 N
0064000 N
verified
 became N in the result because of the master modal-exact rule.

other column min

  • other column min
    Selects the records where a different column contains the lowest value. The
    TARGET-COLUMN
     parameter must be provided.
sdf snippet 

merge-definition
*===============
NAME= person-merge
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= salary-where-oldest
*
merge-column-definition
*===============
NAME= salary-where-oldest
IDTCOLUMN= salary
RULE-SELECTION= oldest
*
merge-column-rule-definition
*===========================
NAME= oldest
TYPE= other-column-min
TARGET-COLUMN= updated
FORMAT= "MDY"
*
Input
Result 

salary  updated
0096500 02142001
0098100 05162009
0080000 01132002
0072400 03272001
0096500 02142001
verified
 became N in the result because of the master modal-exact rule.

other column max

  • other column max
    Selects the records where a different column contains the greatest value. The
    TARGET-COLUMN
     parameter must be provided.
sdf snippet 

merge-definition
*===============
NAME= person-merge
MASTER-SELECTION= modal-exact
COLUMN-SELECTION= name-where-newest
*
merge-column-definition
*===============
NAME= name-where-newest
IDTCOLUMN= name
RULE-SELECTION= newest
*
merge-column-rule-definition
*===========================
NAME= newest
TYPE= other-column-max
TARGET-COLUMN= updated
FORMAT= "DMY"
*
Input
Result 

salary      updated
John Smyth  14122009
John Smith  16112003
J Smith     15012001
John Smith  20112009
John Smyth 14122009
verified
 became N in the result because of the master modal-exact rule.
0 COMMENTS
We’d like to hear from you!