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 Columns in ORS Tables

Types of Columns in ORS Tables

Tables in the
Hub Store
contain two types of columns:
System columns
A column that
Informatica MDM Hub
automatically creates and maintains. System columns contain metadata.
User-defined columns
Any column in a table that is not a system column. User-defined columns are added in the Schema Manager and usually contain business data.
The system columns contain
Informatica MDM Hub
metadata. Do not alter
Informatica MDM Hub
metadata in any way. Doing so will cause
Informatica MDM Hub
to behave in unpredictable ways and you can lose data.


We’d like to hear from you!