Maintain Master Data

[Former Member]

Hi All,

Can anybody explain me in detail what actually maintain reference / master data means in data modelling as well as in other aspects.And can you please explain how this master data should be identified with respect to consolidation point of view.

As we are in the data gathering stage we are in the phase of maintain reference data.so can anybody explain this concept in detail.I am new to this type of work.Can u explain how this type of work should be handled.

cheers.

sunitha.

[Former Member]

Master data are called slowly changing dimensions in data warehouse terminology

Regards,

Rainer

[Former Member]

Sunitha,

Master data, in general, refers to data that does not over a considerable amount of time, or at least not as frequently as transaction data changes. For example, fields like Address of a customer, Name of Customer etc.

We maintain master data in BW in seperate master data tables to reduce redundant uploads of data and also to enhance query read times. Please go through the following to learn more about the start schema, you'll get a good idea:

http://help.sap.com/saphelp_nw04/helpdata/en/4c/89dc37c7f2d67ae10000009b38f889/content.htm

Hope that helps,

Farhan