Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Input Properties

Input Properties

The following table describes input properties for cleanse lists.
Property
Description
Input string
String value from the source system. Used as the target of the search.
searchType
Specifies the type of match (comparing cleanse list items with the input string) to be executed against the input string. One of the following values:
ENTIRE
Compares cleanse list items with the entire string. A match succeeds only when entire input string is the same as a cleanse list item. Default setting if this parameter is not specified.
WORD
Compares the cleanse list items with each word substring in the input string. A match succeeds only if a cleanse list item is a substring flanked by the following word boundaries in the input string: beginning of string, end of string, or a space character.
ANYWHERE
Compares the cleanse list items with any part of the input string. A match succeeds if a cleanse list item is a substring of the input string, regardless of where the substring appears in the input string.
String comparisons are case sensitive.
replaceAllOccurrences
Specifies the degree to which matched substrings in the input string are replaced with the matching cleanse list item. One of the following values.
TRUE
Replaces all occurrences of the matching substring in the input string with the matching cleanse list item.
FALSE
Replaces only the first occurrence of the matching substring in the input string with the matching cleanse list item. Default setting if replaceAllOccurrences is not specified.
If the Strip parameter is TRUE, then occurrences of the matching substring are removed rather than replaced.
stopOnHit
Specifies whether to continue processing the rest of the cleanse list after one matching item has been found in the input string. One of the following values.
TRUE
Stops processing the cleanse list as soon as the first cleanse list item is found in the input string (as long as the searchType condition is met). Default setting if stopOnHit is not specified.
FALSE
Continues to search the input string for the rest of the items in the cleanse list (in order to find any further matching substrings).
Strip
Specifies whether the matched text in the input string will stripped from—or replaced in—the input string. One of the following values.
TRUE
Removes (rather than replaces) the matched text in the input string.
FALSE
Replaces the match text in the input string. Default setting if Strip is not specified.
The replaceAllOccurrences parameter determines whether replacement or removal affects all matches in the input string or just the first match.
defaultValue
Value to use for the output if none of the cleanse list items was found in the input string. If this property is not specified and no match was found, then the original input string is used as the output.

0 COMMENTS

We’d like to hear from you!