Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for Oracle E-Business Suite
  3. PowerExchange for Oracle E-Business Suite Configuration
  4. Oracle E-Business Suite Sources and Targets
  5. Application Source Qualifier Transformation
  6. Oracle E-Business Suite Mappings
  7. Oracle E-Business Suite Sessions
  8. Appendix A: Datatype Reference
  9. Appendix B: Error Messages
  10. Appendix C: Glossary

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

Composite Keys

Composite Keys

When you import a target definition with a composite key, you need to build a unique key from the source composite key using the appropriate transformations. You need to connect this unique key to the GPK of the corresponding group of target definition.
The following figure shows an example of a mapping that uses an Expression transformation to create a unique key from the composite key:
In this example, the PARTY_ORIG_SYSTEM column and the PARTY_ORIG_SYSTEM_REFERENCE column build a composite key. An Expression transformation generates a unique key. This unique key is linked to primary key of the target definition.

0 COMMENTS

We’d like to hear from you!