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

Entity Base Object Example

Entity Base Object Example

In the Product hierarchy in our example, we create one entity base object.
When we create the entity base object, we need to decide how we are going to specify the entity type. In our example, we don't want to use a system-generated row ID number, want to use the meaningful codes Product and Product Group to specify the entity type.
We want to use a foreign key entity type column of our own choice, so we first create a base object with a Product_Type column. If you create a new entity base object, you are not able to specify a customized column name. When we convert this base object to an entity base object, we select the Product_Type column as the entity type foreign key. For this hierarchy, we will create two entity types. The value in the Product_Type column determines to which entity type a record belongs.
The following image shows the selections made to convert the sample entity base object:
The dialog box for configuring an entity base object.
You can then populate the foreign key column in a mapping.

0 COMMENTS

We’d like to hear from you!