I'm looking for some practical tips concerning improving load performance from the PSA to a write-optimized DSO (41M records) via a DTP.
All parameters that could be tweaked have been checked (e.g. packet size, batch jobs, uniqueness of data flag, etc.) and optimized.
However this load stays extremely slow (init load from source to BW is faster).
The BW system runs on SP18.
Please share all your tips our recommendations for us to solve this major issue.
Your help is much appreciated!