5 Replies Latest reply: May 12, 2011 7:34 PM by ramesh mangipudi RSS

Master data and Transaction data question

Kanthi Adapa
Currently Being Moderated

Hi all,

 

I am a newbie to sap bi and have the following question about master data and transaction data.

 

In a hypothetical scenario where:

 

master data table contains the following fields: cust_id, cust_name, cust_phone.

 

transaction data table contains the following fields: cust_id, cust_purchaseamount

 

I understand that master data is loaded less frequently and the transaction data is loaded frequently.

 

I am trying to load Master data first and for that I am creating separate info objects for cust_id, cust_name, cust_phone. I also understand the process to load master data into the BI system by creating a datasource and all that.

 

My question here is, while loading the transaction data, do I create a separate infoobject for cust_id or do I use the one that I created for loading the master data.?

 

If I have to use the same one as one created for master data, will its datasource not be mapped to master data?

If I have to create a new infoobject for cust_id, how will the link be established between this and the infoobject created for master data?

 

I sincerely appreciate any help in this matter.....

Actions