Which data you load first ( MASTER or TRANSACTIOANAL ) ? And why ?

Which data you load first ( MASTER or TRANSACTIOANAL ) ?
And why ?

Question Posted / tapu.sapbw

3 Answers
11771 Views
Bristle Cone, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which data you load first ( MASTER or TRANSACTIOANAL ) ? And why ?..

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

Which data you load first ( MASTER or TRANSACTIOANAL ) ? And why ?..

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

Which data you load first ( MASTER or TRANSACTIOANAL ) ? And why ?..

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

Post New Answer

More SAP BW (Business Warehouse) Interview Questions

Usually we mention T or O in CONFIRMATION TYPE. What is T and O , stand for ?

0 Answers Accenture,

How to check for standard info Objects, InfoCubes, Ods/DSo,transformations, reports, queries..etc in bi7.0/bw3.5? (Is there any T-Codes to find out)

1 Answers

What are transfer rules?

0 Answers

Can you create your own time characteristics?