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.2 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction
  3. Starting Population Override Manager
  4. Purpose Operations
  5. Overriding Frequency Tables
  6. Edit-List Overrides
  7. Rule Definitions
  8. Implementing a Local Population

Population Override Manager

Population Override Manager

Back Next

The Phrase Replacement Rule Type

The Phrase Replacement Rule Type

The phrase replacement process is similar to that performed by the Word Replace logic except that phrase replacement rules can detect and replace multiple words, initials, numbers or codes.
A phrase, and its replacement, each have a maximum length of 50 characters, and each word in a phrase or its replacement has a maximum length of 24 characters.
Both the phrase and its replacement can be one word; however, if both the phrase and its replacement are one word then theWord Replace rule would typically be used.

Phrase Replacement Logic

If a particular Phrase replacement rule is a sub-set of another Phrase replacement rule, and the last word in both rules is the same, the longest phrase definition which matches is used.
For example, if the Edit-List has the following Phrase definitions:
Phrase: SOFTWARE AMERICA
Replacement: XXX
Phrase: SEARCH SOFTWARE AMERICA
Replacement: YYY
then the name :
RESEARCH DIVISION SEARCH SOFTWARE AMERICA
would be produce the following result:
RESEARCH DIVISION YYY
because
SEARCH SOFTWARE AMERICA
 is the longer match of the two entries.
Notice that no
XXX
 replacement will ever take place in his case, because once the replacement is made and the name becomes
RESEARCH DIVISION YYY
, then
SOFTWARE AMERICA
 no longer exists.
After the replacement, the resulting word or phrase is used in a re-lookup of the Edit-List to see if any other rules apply.
There are a number of reasons for defining Phrase Replacement rules.

Acronyms

It is recommended that in most cases the acronym is replaced with its long form. The reason is that there is a greater chance of error in the long form,
For example,
Phrase:IBM
Replacement: INTERNATIONAL BUSINESS MACHINES
Remember, when defining new Edit-List rules, try to make the rules complete to maximize the benefit. In the above example, it would also be important to define a Phrase Replacement rule for:
Phrase:I B M
Replacement: INTERNATIONAL BUSINESS MACHINES
Phrase:INTL BUSINESS MACHINES
Replacement: INTERNATIONAL BUSINESS MACHINES
It is not necessary to define a rule for I.B.M., as the full-stops are removed prior to Edit-List processing.
This example also provides an opportunity to discuss when one might want to use a single word in a phrase and replacement rule. For example, if the word INTERNATIONAL was needed in a number of phrase replacement rules, one can define it once as a single word, and it will be processed before the other rules. Thus defining,
Phrase:INTL
Replacement: INTERNATIONAL
Would alleviate the need for the rule:
Phrase:INTL BUSINESS MACHINES
Replacement: INTERNATIONAL BUSINESS MACHINES

Concatenation

For example,
Phrase:NOT KNOWN
Replacement:UNKNOWN
Phrase:WORLD WIDE
Replacement:WORLDWIDE

Abbreviation

For example,
Phrase:SVC STN
Replacement:SERVICE STATION
Phrase:PTY LTD
Replacement:PROPRIETARY LIMITED

Noise

For example,
Phrase:RECORD DELETED
Replacement:
Phrase:SEE FILE
Replacement:
0 COMMENTS
We’d like to hear from you!