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

Creating Entity, Relationship, and FK Relationship Object Packages

Creating Entity, Relationship, and FK Relationship Object Packages

To create an HM package:
  1. In the Hierarchies tool, right-click anywhere in the navigation pane and choose
    Create New Package
    .
  2. Acquire a write lock.
    The Hierarchies tool starts the Create New Package wizard and displays the first dialog box.
  3. Specify the following information for this new package.
    Field
    Description
    Type of Package
    One of the following types:
    Entity Object
    Relationship Object
    FK Relationship Object
    Query Group
    Select an existing query group or choose to create a new one. In
    Informatica MDM Hub
    , query groups are logical groups of queries. Select the query group under which the query is organized.
    Query group name
    Name of the new query group - only needed if you chose to create a new group above.
    Description
    Optional description for the new query group you are creating.
  4. Click
    Next
    .
    The Create New Package wizard displays the next dialog box.
  5. Specify the following information for this new package.
    Field
    Description
    Query Name
    Name of the query. In
    Informatica MDM Hub
    , a
    query
    is a request to retrieve data from the Hub Store.
    Description
    Optional description.
    Select Primary Table
    Primary table for this query.
  6. Click
    Next
    .
    The Create New Package wizard displays the next dialog box.
  7. Specify the following information for this new package.
    Field
    Description
    Display Name
    Display name for this package, which will be used to display this package in the Packages tool.
    Physical Name
    Physical name for this package. The Hub Console will suggest a physical name based on the display name you entered.
    Description
    Optional description.
    Enable PUT
    Select to enable records to be inserted or changed. (optional)
    If you do not choose this, your package will be read only. If you are creating a foreign key relationship object package, you have additional steps in Step 9 of this procedure.
    Note: You must have both a PUT and a non-PUT package for every Foreign Key relationship. Both Put and non-Put packages that you create for the same foreign key relationship object must have the same columns.
    Secure Resource
    Select to create a secure resource. (optional)
  8. Click
    Next
    .
    The Create New Package wizard displays a final dialog box. The dialog box you see depends on the type of package you are creating.
    If you selected to create either a package for entities or relationships or a PUT package for FK relationships, a dialog box similar to the following dialog box is displayed. The required columns (shown in grey) are automatically selected — you cannot deselect them.
    Deselect the columns that are not relevant to your package.
    You must have both a PUT and a non-PUT package for every Foreign Key relationship. Both Put and non-Put packages that you create for the same foreign key relationship object must have the same columns.
    If you selected to create a non-Put enabled package for foreign key relationships (see Step 7 of this procedure - do not check the Put check box), the following dialog box is displayed.
  9. If you are creating a non-Put enabled package for foreign key relationships, specify the following information for this new package.
    Field
    Description
    Hierarchy
    Hierarchy associated with this package.
    Relationship Type
    Relationship type associated with this package.
    You must have both a PUT and a non-PUT package for every Foreign Key relationship. Both Put and non-Put packages that you create for the same foreign key relationship object must have the same columns.
  10. Select the columns for this new package.
  11. Click
    Finish
    to create the package.
Use the Packages tool to view, edit, or delete this newly-created package.
You should not remove columns that are needed by
Hierarchy Manager
. These columns are automatically selected (and greyed out) when the user creates packages using the Hierarchies tool.

0 COMMENTS

We’d like to hear from you!