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: Glossary

Step 2: Creating Relationship Base Object Tables

Step 2: Creating Relationship Base Object Tables

Having analyzed the data, John comes to the following conclusions:
  • Product (the BO) should be converted to an Entity Object.
  • Product Group and Product are the Entity Types.
  • Product Rel is the Relationship Object to be created.
  • The following relationship types (not all shown in the table) need to be created:
    - Product is the parent of Product (not shown)
    - Product Group is the parent of Product (such as with the Mice to Laser Mouse example).
    - Product Group is the parent of Product Group, such as with Mice + Pointers being the parent of Mice).
John begins by accessing the Hierarchy Tool. When he accesses the tool, the system creates the Relationship Base Object Tables (RBO tables). RBO tables are essentially system base objects that are required base objects containing specific columns. They store the
HM
configuration data, such as the data that you see in the table in Step 1.
For instructions on how to create base objects, see Creating Base Objects. This section describes the choices you would make when you create the example base objects in the Schema tool.
You must create and configure a base object for each entity object and relationship object that you identified in the previous step. In the example, you would create a base object for Product and convert it to an
HM
Entity Object. The Product Rel BO should be created in
HM
directly (an easier process) instead of converting. Each new base object is displayed in the Schema panel under the category Base Objects. Repeat this process to create all your base objects.
In the next section, you configure the base objects so that they are optimized for
HM
use.

0 COMMENTS

We’d like to hear from you!