Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

SAP ETL Performance Tuning Questions (Part - 5)


Performance Tuning 

200. What are the data load tuning one can do?
 Load balance on different servers
 Indexes on source tables
 Use fixed length files if data is loaded from flat files and put the file on the application server
 Use content (SAP delivered) extractor as much as possible
 Use “PSA and Data target in parallel” option in the InfoPackage
 Start several InfoPackages parallel with different selection options
 Buffer the SID number ranges when lot of data is loaded at once
 Load Master Data before loading Transaction Data
 Watch out the ABAP code in transfer and Update rules – This might slow performance
201. What are the general tuning guidelines?
 Archive and delete old data
 Use line item dimensions for large dimensions
 Use MultiProviders to parallel query on the basic InfoCubes
 Use the BW statistics InfoCube to monitor performance
 Reporting authorizations slow the performance
 Web reporting is faster than BEx reporting
 Use the aggregate hierarchies to minimize the roll-up time
 Use parallel upload and activation of ODS objects
 Disable the BEx reporting flag if ODS is not used for reporting
202. Ways to improve the performance
 Define as many dimensions as possible.
 Create aggregates
 Check and define Line Item Dimension

2 comments:

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget