Data Director User Guide

10.5 HotFix 4

Back Next

Configuring the Associate Sibling Lookup

To configure the associate sibling lookup, ensure that you create a new field in the Business Object that requires to be associated with its child or sibling.

As part of the creation stage, create a new field that you want to associate with its child or sibling.

For example, you want to associate

Party

with

The following image shows how to create the

Person_email

in the

Party

business object:

Set up a Foreign Key relationship in the Business Entity.

For example, establish a foreign key relationship between the

Person_Email

and the

Party Electronic Address Rowid Object

on the Add Relationship dialog box.

The following image shows how to establish a foreign key relationship on the

Relate from

and

Relate To

sections on the Add Relationship dialog:

The image shows the Find pane where the Party has Relationships selected. Under the Party Relationships, the Add Relationship dialog appears. Under the Relate from section, Person_Email is selected. Under the Relate to section, the Party Electronic Address appears with the Rowid Object selection.

The following diagram shows the foreign key table references that you create from

Person_Email

to the

Party Electronic Address Rowid Object

on the Add Relationship dialog box:

The image shows the Properties tab. Under the Table references section, you can see the following text: Foreign Key from "Party (Person_Email)" to "Party Electronic Address (Rowid Object)" (Restrict) [Virtual].

On the Provisioning tool, create a new lookup field with the new relationship.

For example, create a new lookup field under the Business Entity that has the foreign key relationship with email, which is the

Person_Email

business entity.

Select the constraint as the new relationship configured in the MDM Hub Console before you apply the changes and publish.

For example, the Sibling or Child reference in the new field added to the Provisioning tool.

The following diagram shows the Lookup display field selected whose value displays in the associated lookup field:

The image shows the Home page. Under Modelling, the Business Entities option and the suboption called Person is selected. Under the Person, the lookup fields option is selected. Under the Lookup field, there is a new lookup field. The new lookup field has the Name and Label as PersonEmail, Sibling or child reference is selected, objects is Emails, constraint is updated, and the Lookup display field has electronic address.

Add a new field in the Business Entity View.

The following image shows how to add a new field in the Business Entity View:

The image shows the Home page. Under Modelling, the Business Entities Views option and the suboption called PersonView is selected. Under the PersonView, the fields option is selected. Under the fields, there is a Person Email field. The Person Email field has the Name and Label as Person_Email along with other properties, such as Depends ON, URI, Type, Display Format, Length, Total Digits, and Fraction Digits.

Add a transformation for the newly created field.

The following image shows how to add a transformation for the new field in the Business Entity to View:

The image shows the Business Entity tab. Under Transformations, you can see the Business Entity to View option and the suboption called Person_PersonView is selected. Under the Person_PersonView, there is a transformations folder where direct option is selected. You can see the Person Email too on the next pane.

The following image shows how to add a transformation for the new field in the View to Business Entity:

The image shows the Business Entity tab. Under Transformations, you can see the View to Business Entity option and the suboption called PersonView_Person is selected. Under the PersonView_Person, there is a transformations folder where direct option is selected. You can see the Person Email too on the next pane

Apply and publish the changes.

Verify the associated sibling lookup field in the Informatica Data Directory.

Create a new Person business entity.

The following image displays the configured sibling lookup field:

The image shows the New Person record where the PersonView contains the Person_Email option with the magnifying glass icon and the delete icon next to it.

Click on the magnifying glass icon to see the list of email IDs created for a specific person.

The following image displays the list of email IDs created for a specific person:

Select one the emails added and click

In the example, since you selected the Lookup display field as Email Address in Provisioning, the value displayed in the

Person_Email

field is

email1@gmail.com

as seen in the following image:

Rename Saved Search

Table of Contents

Data Director User Guide

Data Director User Guide

Configuring the Associate Sibling Lookup

Configuring the Associate Sibling Lookup