master data load query
Why is master data loaded before loading transaction data for better performance?
Your help will be very much appreciated.
if master data is missing then trans data will error when you try load/activate. Always load Master Data before Trans data.
You can oad transactions data first if you want to, but from a performance standpoint, it beter to load master data first.
When you load master data, SIDs are assinged to any new values and the master data is populated with all the attributes that you are loading. Then when transactions are loaded, the master master data is read to obtain the SIDs.
If you load ransactions first, the BW tries to go get the SIDs, doesn't find them, so it has to create a SID and master data records that are not complete as there are no on attribute values known at that point. Then when the master data is finally loaded, it has to figure out that there are already master data records setup, but it must update them to fill in the missing values. There's just a lot more DB overhead doing this so you want to avoid it.
Assign Points if useful..