| |
GeekInterview.com > Interview Questions > Data Warehousing > Concepts
| Print | |
Question: definition of datamarts?
|
| January 01, 2007 04:09:15 |
#2 |
| anilreddy27 |
Member Since: January 2007 Total Comments: 2 |
RE: definition of datamarts?
|
| Datamarts are the partitions of the overall datawarehouse. Datwarehouse covers as every aspect of the company's business, then datamart is a subset of that huge datawarehouse.Datawarehouse is limited to the resource constraints and priorities of the MIS organization. But, the task of the implementing Datwarehouse needs big effort and takes significant amount of time. It Impacts on return on investment.So, the feasible option is to start a set of datamarts for each of the component departments.Simply, we can say a set of small, more managable databases are called datamarts.2 types of datamarts are there.1. Standalone datamarts: It enables a department or workgroup to implement a datamart with minimal or no impact on the Enterprise's operational database.2. Dependant datamarts: Enterprise database is required for these marts. Datasources includes operational databases and external sources of data. |
| |
Back To Question | |
