A Data ware house is a logical collection of information gathered from many different operational subject area used to create business intelligence that supports business analysis and top level decision making purpose.
It can holds multiple subject areas with very detailed (Historical) information.
We created Data ware house to integrate all homogeneous/ heterogeneous data sources.
Example: A "HRCORE" Data ware house is collection of 4 subject areas
1. Employee Assignment
2. Employee request
3. Employee Time sheet
4. Employee Expenses
A Data mart is a logical collection of only one subject area information.It is
a subset of the data warehouse which is usually oriented to a specific business line or team.
Example: In "HRCORE" Data ware house, each subject area is one data mart.
Employee Assignment, Employee request, Employee Time sheet and Employee Expenses.
MORAL: Data warehouse can contain many subject areas, and a data mart can contain just one of those subject areas. A Data Mart is subset of a Data ware house.
No comments:
Post a Comment