Which data you load first ( MASTER or TRANSACTIOANAL ) ?
And why ?
Answers were Sorted based on User's Feedback
Answer / ritesh wakode
The master data is loaded first. Because , it determines how transactions happens and which way it is to be happened. The master data is building block, upon which we maintain the record of the transactions as they takes place.
Is This Answer Correct ? | 13 Yes | 4 No |
Answer / vijay
im vijay from syntel, first load the master data becz of
SID's, thats why first we load master data first , next
transaction data.
if you load transaction data first, next master data, it
gives performance problems, SID problems, query related
errors...
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / govardhanreddysapbw@gmail.com
This is Govardhan... we have to load Master data first..Bcoz if you load the transitional data first then its ended up with
error as NO SID FOUND which is you were posted LUW. then we have to load the Master data prior to Transcriptional data.
Bcoz in every business transaction, what ever data has generated needs to fetch the data from Master data of Dimensional tables.
Is This Answer Correct ? | 3 Yes | 2 No |
What are events and how you use it in BW?
Hi friends gm to all , i had done bi with integrating planning. and I have full knowledge on integrating planing, but I don't faced any interview's in ip now, So friends have we any interview questions like Integrating planning, pls send my mail ID.
What is the use of db connection in sap bw data acquisition?
How would you change the default template?
what do you mean by update routines
What is data flow in bw/bi?
What is the table filled when you select ABAP?
Give some examples of usage of BW statistics reports?
What is the DIM ID?
What are the options available when you define conditions with respect to characteristics combination?
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?