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 3. Create the Product Relationship Object

Step 3. Create the Product Relationship Object

The Product relationship object maintains the hierarchy relationships associated with the Product entity object. To create the Product relationship object, you can either convert an existing base object, or create the Product relationship object. In this tutorial, we will create the Product relationship object.
  1. In the Model workbench, click
    Hierarchies
    .
  2. Select
    Hierarchies
    Create New Entity/Relationship Object
    .
  3. Select
    Create New Relationship Base Object
    . Click
    OK
    .
  4. Enter the following parameters for the relationship object:
    Parameter
    Parameter Value
    Display name
    Product Rel
    Physical name
    C_PRODUCT_REL
    Data Tablespace
    CMX_DATA
    Index Tablespace
    CMX_INDX
    Description
    Optional.
    Secure Resource
    Enabled
    Entity Base Object 1
    Product
    Display Name
    Product ID1
    Physical Name
    PRODUCT_ID1
    Entity Base Object 2
    Product
    Display Name
    Product ID2
    Physical Name
    PRODUCT_ID2
    Hierarchy FK Column
    Row ID Object
    Hierarchy FK Display Name
    Row ID Hierarchy
    Hierarchy FK Physical Name
    ROWID_HIERARCHY
    Rel Type FK Column
    Row ID Object
    Rel Type FK Display Name
    Row ID Rel Type
    Rel Type FK Physical Name
    ROWID_REL_TYPE
  5. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!