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 |
When you create a datasource some flags are attached for each filed; what are they?
Will customers continue to receive support for older versions of sap bw?
Describe a opening balance?
Which of the tables are inside and outside cube in an extended star schema?
How is archiving advantageous?
What is partition of an infocube?
What are the table structures associated with ODS?
What is the name restriction on field when you append structure?
where can i found more interview qustions on bw and bi
Where will you get more information on the delta methods?
why ods activation fail? What types of fails are there? What are the steps to handle
what is the diffarence between formula and caluculated key figure.