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

Master Rules

Master Rules

This section provides information on the options in the Master Rules.
  • modal exact
    Selects the records with the greatest number of columns 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 * merge-master-definition *====================== NAME= modal-exact TYPE= modal-exact *
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 filled

  • modal exact
    Selects the records with the greatest number of columns filled.
sdf snippet
merge-definition *=============== NAME= person-merge-most-filled MASTER-SELECTION= most-filled * merge-master-definition *====================== NAME= most-filled TYPE= most-filled *
Input
Result
Name Addr updated John Smith 14072008 John Smith 12 Main Street 13072008 Jon Smith 12 Main Street
John Smith 12 Main Street 13072008

most data

  • most data
    Selects the records with the most data (longest sum of string lengths). Column with a NULL value will not add to the total length
sdf snippet
merge-definition *=============== NAME= person-merge-most-data MASTER-SELECTION= most-data * merge-master-definition *====================== NAME= most-data TYPE= most-data *
Input
Result
Name Addr updated John Smith 12 Main Street 14072008 John Smith 12 Maine Street 13072008 John Smythe 12 Maine Street
John Smith 12 Maine Street 13072008

column max

  • column max
    Selects the records with the greatest value in a particular column. The COLUMN field must be provided.
sdf snippet
merge-definition *=============== NAME= person-merge-newest MASTER-SELECTION= newest * merge-master-definition *====================== NAME= newest TYPE= column-max COLUMN= updated * merge-column-definition *====================== NAME= updated FORMAT= "DMY" *
Input
Result
Name Addr updated John Smith 12 Main St 14072009 John Smith 12 Maine Street 13072009 Jon Smith 12 Main Street 14082009 John Smyth 12 Maine Street 13082009
Jon Smith 12 Main Street 14082009

column min

  • column min
    Selects the records with the lowest value in a particular column. The COLUMN field must be provided.
sdf snippet
merge-definition *=============== NAME= person-merge-oldest MASTER-SELECTION= oldest * merge-master-definition *====================== NAME= oldest TYPE= column-min COLUMN= updated * merge-column-definition *====================== NAME= updated FORMAT= "DMY" *
Input
Result
Name Addr updated John Smith 12 Main St 14072009 John Smith 12 Maine Street 13072009 Jon Smith 12 Main Street 14082009 John Smyth 12 Maine Street 13082009
John Smith 12 Maine Street 13072009

column equals

  • column equals
    Selects the records where a particular column equals a given value. The COLUMN and VALUE fields must be provided.
sdf snippet
merge-definition *=============== NAME= person-merge-verified MASTER-SELECTION= column-verified-equals * merge-master-definition *====================== NAME= column-verified-equals TYPE= column-equals COLUMN= verified VALUE= Y *
Input
Result
name street verified updated John Smith 12 Main St N 14072009 John Smith 12 Maine Street N 13072009 John Smyth 12 Maine Street Y 13082009
John Smyth 12 Maine Street Y 1308200909

0 COMMENTS

We’d like to hear from you!