PowerExchange for LDAP User Guide for PowerCenter

10.5
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Generating Key Values

When you import an LDAP target definition, the Designer creates a key relationship between a group in the target definition and its parent group.

When you create mappings with the primary key-foreign key relationship, the Designer might not create the relationship for the tables. You need to manually set the primary key relationship in the foreign key table.

For more information about the naming conventions, see Generating Key Values.

For the multi-valued target, the Designer generates the primary key GPK__Parent_Group for the parent group. The Designer generates the primary keys, GPK__mail and GPK__ou for the child groups. The Designer generates GFK__Parent_Group__mail and GFK__Parent_Group__ou foreign keys for the child groups.

The GPK is a unique field of the data rows for the child group. The GFK field relates each child group row with a parent group entry. Verify that the values of GFK field are selected from the values provided for the GPK field in the parent group.

The GPK and GFK fields must not be NULL. If GPK and GFK fields are NULL, the PowerCenter Integration Service writes an error in the session log.

Rename Saved Search

Table of Contents

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Generating Key Values

Generating Key Values