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