Metadata Manager User Guide

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

Back Next

Creating and Deleting Relationships

To create or delete relationships in a custom resource:

In the metadata catalog, select a custom resource.

Click Actions > Object Relationships Wizard.

- or-

Right-click and select Object Relationships Wizard.

Step 1 of the Object Relationships Wizard appears.

In the Associated Resource list, select the level of the custom resource hierarchy that contains the objects for which you want to create or delete relationships.

Metadata Manager shows the resources and objects that have class-level relationships to objects in the custom resource. Metadata Manager also displays the parent objects of the metadata objects. Metadata Manager displays the parent objects even if they do not have class-level relationships with the objects in the custom resource.

Configure the following options:

Option	Description
Include immediate parent while doing name-based search	The property of both the parent and child objects to which you want to create relationships match the property of the parent and child objects you want to create relationships for.
Case sensitive	Metadata Manager performs a case sensitive match when it searches for matching properties.

Click Next.

Step 2 of the Object Relationships Wizard appears.

Select the class attributes for each resource that you want to match.

For example, to match column names, choose the name attribute for each column class.

Click Next.

The wizard displays the matching objects and selects all relationships.

Clear Add for all objects for which you do not want to create a relationship.

If a relationship exists and you clear the check box, Metadata Manager deletes the relationship.

If the metadata object is related to a reusable PowerCenter object, you can delete the relationship to the reusable object. Metadata Manager removes the associations to all instances of the object. However, you cannot delete the relationship for a single instance of the object.

Click Finish.

Metadata Manager creates or deletes the relationships.

Creating and Deleting Multiple Relationships

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal