Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Viewing Metadata
  4. Searching Metadata
  5. Working with Shortcuts and Folders
  6. Editing Metadata
  7. Working with Data Lineage
  8. Sharing Metadata
  9. Business Glossaries
  10. Using the URL API
  11. Configure the Web Browser
  12. Glossary

Metadata Manager User Guide

Metadata Manager User Guide

Creating Relationships Example

Creating Relationships Example

A custom resource, ACCESS_DB, contains database table objects that have class-level relationships with database table objects in an Oracle resource. You want to create relationships between the custom metadata objects and the Oracle database table objects.
When you run the Object Relationships Wizard for the ACCESS_DB resource, you specify to match all column objects that have the same property name for the table column class.
The following table shows the relationships that have matching object names:
Object Name
Matched Object Name
ACCESS_DB_SOURCE/ CUSTOMER/ SRC_CUSTOMER
SCHEMA/ CUSTOMER/ SRC_CUSTOMER
ACCESS_DB_SOURCE/ PRODUCT/ SRC_CUSTOMER
SCHEMA/ CUSTOMER/ SRC_CUSTOMER
ACCESS_DB_SOURCE/ PRODUCT/ SRC_CUSTOMER
SCHEMA/ PRODUCT/ SRC_CUSTOMER
ACCESS_DB_SOURCE/ PRODUCT/ SRC_CUSTOMER
SCHEMA/ SALES/ SRC_CUSTOMER
Metadata Manager searches for parent and child table objects in the ACCESS_DB resource that have the same name as the corresponding objects in the Oracle resource.
The following table shows the relationships that have matching parent and child object names:
Object Name
Matched Object Name
ACCESS_DB_SOURCE/ CUSTOMER/ SRC_CUSTOMER
SCHEMA/ CUSTOMER/ SRC_CUSTOMER
ACCESS_DB_SOURCE/ PRODUCT/ SRC_CUSTOMER
SCHEMA/ PRODUCT/ SRC_CUSTOMER

0 COMMENTS

We’d like to hear from you!