master data load query

[Former Member]

Hello gurus,

Why is master data loaded before loading transaction data for better performance?

Your help will be very much appreciated.

Thanks

S N

[Former Member · Accepted solution]

Hi,

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..

-Shreya

[Former Member]

hi sn,

this is the design of bw star schema; cauz sid are created first and linked to dim tables thereafter

example permanent data is loaded first as compare to daily chnges data

nain

[Former Member]

S N,

Disadvantage is Loading time is High as SIDS are to be created since Master Data not loaded and in the reports one might not see the Description or any attributes related to that Master Data

LOOK-UPS (Refer to Master Data) to be made while Loading Transaction Data in that case you just cant load Transaction Data without Loading Master Data.

-Doodle

[Former Member]

Hi,

If master data is not loaded and while loading Transactional data in Infopackage if check box " load data even though no corresponding master data is present is ticked " and in rscustv7 Create Master Data when loading Transaction Data is given . Then System will try to create the Master data and corressponding SID's if sales comes for missing Characteristic Values and this may consume lot of time depending on the load size . If master data is already loaded then SID would have generated and while transactional Data load it will just resuse SID.

Also As doodle said , if user refreshes report which shows master data attributes then attribute values of newly master data will be Missing until master data is loaded.

Assign Points if it Helps.

Regards,

Vijay