DTP的优化

某印度鬼子写的文章

http://scn.sap.com/community/data-warehousing/bw/blog/2016/02/25/how-to-optimise-the-long-running-loads-by-dtp-settings

1. 语义组中做了选择

2. 勾选了通过申请获取所有数据请求。Get All data request by request

有待进一步研究。

Tinkering with DTP Package Sizes, Semantic Keys and Batch Processes can only save you so much time. Beyond that you need to start looking into the ABAP logic in the transformations.

Reducing the number of direct database reads, ensuring you sort your tables and use binary search where possible, removing unecessary loops, favouring Start and End Routine over Row level routines will grant you even larger performance gains.