Hi,
I will be loading more than 3 million records from a flat file every week.
I tuned RSCUSTV6, the infocube dimensions (creating line-itemsdims), use number range buffering, have a fixed length ASCII file, load Target and PSA in parallell. The load is now taking 2 hours.
In order to speed this up I want to split the Flat file in 4 pieces and load these in parallell. However, these loads are locking each other (SM12, ENQUEUE) when I start them manually.
What to do?
SOlved the problem by changing the setting in the infopackage; Only load Data Target. The load now takes 30 min. for 3million records
Message was edited by: F. Padt