Explain data mart.

1.	Explain data mart.
Answer» An enterprise data WAREHOUSE can be divided into subsets, also called data marts, which are focused on a particular business unit or department. Data marts allow selected groups of users to easily access specific data without having to SEARCH through an entire data warehouse. Some companies, for example, may have a data mart aligned with purchasing, SALES, or inventories as shown below: In contrast to data warehouses, each data mart has a UNIQUE set of end users, and building a data mart takes less time and costs less, so it is more suitable for SMALL businesses. There is no duplicate (or unused) data in a data mart, and the data is updated on a regular basis.

Answer»

An enterprise data WAREHOUSE can be divided into subsets, also called data marts, which are focused on a particular business unit or department. Data marts allow selected groups of users to easily access specific data without having to SEARCH through an entire data warehouse. Some companies, for example, may have a data mart aligned with purchasing, SALES, or inventories as shown below:

In contrast to data warehouses, each data mart has a UNIQUE set of end users, and building a data mart takes less time and costs less, so it is more suitable for SMALL businesses. There is no duplicate (or unused) data in a data mart, and the data is updated on a regular basis.

Discussion

No Comment Found

Related InterviewSolutions

Explain the data cleaning process.
What do you mean by ETL Pipeline?
What is BI (Business Intelligence)?
Write the difference between ETL testing and database testing.
What is data source view?
Write about the difference between power mart and power center.
State difference between ETL and OLAP (Online Analytical Processing) tools.
What do you mean by data purging?
Explain how a data warehouse differs from data mining.
Explain data mart.