Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for LDAP
  3. PowerExchange for LDAP Configuration
  4. LDAP Sources and Targets
  5. LDAP Mappings
  6. LDAP Sessions
  7. Appendix A: LDAP Datatype Reference
  8. Appendix B: Error Messages
  9. Appendix C: Glossary

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Orphan and Duplicate Rows

Orphan and Duplicate Rows

Multi-valued attributes have primary key-foreign key relationships with single-valued attributes.
Each group in an LDAP target contains a dummy primary key, and each group other than the parent group contains a dummy foreign key. Use the source fields or the PowerCenter transformations to enter the dummy keys. If the value for a foreign key in a child group is not from the list of the values for the primary key of the first parent group, the child row is treated as an orphan row. If the value of a primary key is duplicated in more than one row in a particular group, these rows are treated as duplicate rows.
The PowerCenter Integration Service loads the data rows into the LDAP directory server that retains the primary key-foreign key relationship. The orphan and duplicate rows are discarded. For more information about orphan and duplicate rows, see Configuring Sessions for LDAP Targets.

0 COMMENTS

We’d like to hear from you!