Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: SAP Table Data Extraction
  4. Part 3: SAP BW OHS Data Extraction
  5. Part 4: SAP BW Data Load
  6. Part 5: SAP Pushdown Optimization
  7. Appendix A: Data Type Reference

PowerExchange for SAP NetWeaver User Guide

PowerExchange for SAP NetWeaver User Guide

PSA Transfer Method

PSA Transfer Method

Use the PSA transfer method when you want to load data into the Persistent Storage Area (PSA) before you write the data to an Operational Data Store (ODS) or InfoCube. When you use the PSA transfer method in SAP BW, the Data Integration Service loads the data to SAP BW. SAP BW stores the data in a PSA, and then updates or transforms the data.
When you use a 7.x DataSource to load data to SAP BW version 7.3, the transfer option is set to load data to the PSA because the InfoPackage loads data only to the PSA.
When you use 3.x data sources to load data to SAP BW, you can use one of the following PSA transfer options:
PSA and then into Data Targets
Select this option when you want to store data in the PSA before you load the data to data targets such as an ODS, InfoCube, or InfoSource.
PSA and Data Targets in Parallel
Select this option when you want to load data to the PSA and the data targets at the same time to achieve high performance.
Only PSA
Select this option when you want to load data only to the PSA. You can also select the
Update Subsequently in Data Targets
option to load the data to data targets after you load the data to the PSA.
Data Targets Only
Select this option when you want to load data only to data targets such as an ODS, InfoCube, or InfoSource.
For optimal performance, configure the transfer option to load data to the PSA. After the source system loads the PSA, you can update the InfoCubes in SAP BW.

0 COMMENTS

We’d like to hear from you!