SAP BW 360 - Day 4

In day 4, we learn about a bit about SAP BW extraction and loading and how to improve performance. So basically, the rule of thumb for extraction and loading is that, for full data load, you have to delete the index first before loading, and recreate it after that. Because, it will be much slower to extract and load data when indexing exist.

For, incremental loads, again depends on how much the difference is, if it's more than 20% of the original data, then you might as well just delete the index.

Also, when you do BW extraction and loading, bear in mind that the more "customized" rules you have, be it routines or just formula, either in transfer or update rules, the more will it affect performance.

Another thing, for loading, you should also 'tweak' the package size in the infopackage scheduler. This package size will determine the size of each packet transmitted during extraction.

2 comments:

Mon Feb 27, 07:07:00 PM 2006 Anonymous said...

good stuff.
Looking forward for the fifth day...

Mon Dec 17, 06:53:00 PM 2007 Prashant said...

Very nice...

Could you please give any references for the thumb rule 'For, incremental loads, again depends on how much the difference is, if it's more than 20% of the original data, then you might as well just delete the index.'

Thanks for sharing it with great approach and great content.