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

Selecting Multiple Columns for Matching

Selecting Multiple Columns for Matching

If you specify more than one column for matching:
  • Values are concatenated into the field used by the match purpose, with a space inserted between each value. For example, you can select first, middle, last, and suffix columns in your base object. The concatenated fields will look like this (a space follows the last word in the string):
    first middle last suffix
    For example:
    Anna Maria Gonzales MD
  • For data containing spaces or null data:
    • If there are spaces in the data, then the spaces remain and the field is not NULL.
    • If all the fields are null, then the combined value is null.
    • If any component on the combined field is null, then no extra space will be added to replace the null.
Concatenating columns is not recommended for exact match columns.

0 COMMENTS

We’d like to hear from you!