Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Step 2. Create a Mapping

Step 2. Create a Mapping

When you import InfoSources or DataSources into the Target Designer, the PowerCenter repository stores them as target definitions. You can use these target definitions in mappings that load data into SAP BI.
The following restrictions apply to building mappings with InfoSource and DataSource targets:
  • You cannot use SAP BI as a lookup table.
  • You can only use one transfer structure for each mapping.
  • You cannot execute stored procedures in an SAP BI target.
  • You cannot build update strategy in a mapping. SAP BI supports only inserts. It does not support updates or deletes. You can use an Update Strategy transformation in a mapping, but the PowerCenter Integration Service attempts to insert all records, including those marked for update or delete.

0 COMMENTS

We’d like to hear from you!