4. What are the factors to consider while extracting data from source
system?
Data load performance can be affected by following key
aspects.
Customer exits. à Check with RSA3, SE30 and ST05
Resource utilization. à SM50 / SM51
Load balancing. à SM50 / SM51 (Configure ROIDOCPRMS)
Data package size.
Indices on tables. à ST05
Flat file format.
Content Vs generic extractor. The size of the packages depends on the
application, the contents and structure of the documents. During data
extraction, a dataset is collected in an array (internal table) in memory. The
package size setting determines how large this internal table will grow before a
data package is sent. Thus, it also defines the number of Commit's on DB
level.
Use RSMO and RSA3 to monitor the load.
Indices can be built on Data Source tables to speed up the selection
process.
If there is a poor performance in data load, refer the following
note
Note 417307 - Extractor package size: Collective note for
applications.
If you define selection criteria in your
Info Package and the selection of the data is very slow, consider building
indices on the Data Source tables in the source system.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/768773/viewspace-627547/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- Explore the relation between BEx Tables
- Important Transaction Codes For BW
- [网络文摘] Query Optimization
- [网络文摘]How to Improve Query Performance - A Checklist
- Types of Update Methods
- Designing Executive Dashboards (Part 2)
- Designing Executive Dashboards
- FAQ about Xcelsius and SAP NetWeaver BI Connection
- BW system tuning - 10
- BW system tuning - 9
