Document on Data Mart

[Former Member]

Hi,

Can anyone please provide me some documents on Data Mart,

What exactly we mean by it, why we use it and where we use it.

Thanks

dipka

[Former Member]

This message was moderated.

[Former Member]

Hi Dipika,

Havig a datamart or not having a data mart totally depends on what do you want to do. Let me give you an example. You bring in data from the source and load into a ODS or a cube. The same cube has potential to be used by different business areas or divisions in your organization. But their data requirements are slightly different from what the cube / ods has. In that case, it is a practice to make the cube a data mart by generating export data source. From this data mart / export data sourc you apply the busines slogic of each division / busines area, transform the data and load into the reporting cubes.

It is hard to pinpoint advantages and disadvantages of data mart. Advantage is each business area / division has their own rrporting cube and you can maintain authorization accordingly. Disadvantage is you tend to keep data in multiple cubes.

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6110e07211d2acb80000e829fbfe/content.htm

Hope this helps...

Regards

Pcrao.

[Former Member]

Hi ,

Actaully ..Data Mart - Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.

Data warehouses and data marts are built on dimensional data modeling where fact tables are connected with dimension tables. This is most useful for users to access data since a database can be visualized as a cube of several dimensions. A data warehouse provides an opportunity for slicing and dicing that cube along each of its dimensions.

Data Mart: A data mart is a subset of data warehouse that is designed for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be derived from an enterprise-wide data warehouse. In an independent data mart, data can be collected directly from sources.

Hope this helps you ..

Regards,

Shikha

[Former Member]

This message was moderated.