We have implemented Sales Simulation Datasource (0UC_SALES_SIMU_03) recently and performed the full data from ISU to Write-Optimized DSO in BW4HANA for loading the historical data. It took 4 Days 17Hr to complete for appx.311 Million records and for weekly delta loads it is taking 1 Complete Day for loading 78-80 Million records. There are few customization being done at extractor level.
Please note the same Extractor is taking 3 Hour in our old SAP BW7.5 system for weekly loads.
After further analysis I have noticed that the load is taking maximum time in the step highlighted below ( Prepare for Extraction ). It seems HANA is bringing all the records sequentially and then distributing into packages. Also as it is BW4HANA , we don't have control on package size and HANA is assigning the package size on itself.
Hence would like to know what could be the possible steps/improvements that can be done in order to load the data much faster in BW from Source.