A data warehouse in an Enterprise reporting solution. It will typically hold all historical data for the company for all time.
A datamart is a smaller version of the data warehouse. It's going to hold a year or two's worth of information, and may not hold all the tables in the data warehouse. While the data warehouse is for the enterprise, a datamart is typically for a departments use.
Last Wiki Answer Submitted: March 21, 2008 7:15 am by Denny Cherry64,520 pts.
All Answer Wiki Contributors: Denny Cherry64,520 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
DATAMART & DATAWAREHOSE
Check out SearchDataManagement.com’s expert answer to this question: Data mart vs. Data warehouse. It’s very thorough and comprehensive.