DTP processing very slow
I am currently doing testing in our BI 7 sandbox (which is a copy of BW PRD).
I have migrated the 3.x datasource 0FI_AP_4 and created transformations and a DTP to load the data from PSA to cube 0FIAP_C03.
In our BW 3.5 a full load from R/3 was taking 4 minutes.
In my testing scenario the load using an InfoPackage from R/3 to the PSA takes 2 minutes.
However, the time it takes the DTP to load the data from PSA to the InfoCube is around 6 hours. it has loaded Data Packages serially one after the other each taking around 7 minutes.
Any hints to how I make my DTP much faster.
I will reward points to useful answers.