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

Creating the HM Repository Base Objects

Creating the HM Repository Base Objects

To use the Hierarchies tool with an ORS, the system must first create the Repository Base Objects (RBO tables) for the ORS. RBO tables are essentially system base objects.
They are required base objects that must contain specific columns.
Queries and packages (and their associated queries) will also be created for these RBO tables.
Never modify these RBO tables, queries, or packages.
To create the RBOs:
  1. Acquire a write lock.
  2. Start the Hierarchies tool. Expand the Model workbench and click
Any option that you can select by right-clicking in the navigation panel, you can also choose from the Hierarchies tool menu.
After you start the Hierarchies tool, if an ORS does not have the necessary RBO tables, then the Hierarchies tool walks you through the process of creating them.
The following steps explain what to select in the dialog boxes that the Hierarchies tool displays:
  1. Choose
    in the Hub Console dialog to create the metadata (RBO tables) for HM in the ORS.
  2. Select the tablespace names in the Create RBO tables dialog, and then click


We’d like to hear from you!