Metadata Manager User Guide

10.5.8
- 10.5.9
- 10.5.7
- 10.5.6
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

Metadata Manager User Guide

Metadata Manager User Guide

Creating Relationships Example

Creating Relationships Example