Table of Contents


  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Types of String Matches

Types of String Matches

For the output string, you can specify one of the following match types:
Match Type
Exact Match
Text string (for example, “IBM”). Note that string matches are not case sensitive. For example, the string test will also match TEST or Test.
Regular Expression
Pattern using the Java syntax for regular expressions (for example, “I.M.*” would match “IBM”, “IB Corp” and “IXM Inc.”). To parse a name field that consists of first, middle, and last names, you could use the regular expression (\S+$), which gives you the last name no matter what name you give it.
The regular expression that is typed in as a parameter is used against the string and the matched output is sent to the outlet. You can also specify the group number to match an inner group of the regular expression. Refer to the Javadoc for java.util.regex.Pattern for the documentation on the regular expression construction and how groups work.
SQL Match
Pattern using the SQL syntax for the LIKE operator in SQL (for example, “I_M%” would match “IBM”, “IBM Corp” and “IXM Inc.”). If you use metacharacters such as the pipeline symbol (|), the metacharacter must be delimited by an escape sequence such as backslash (\).


We’d like to hear from you!