Exforsys

Online Training

Difference between Data Warehousing and Datamart

This is a discussion on Difference between Data Warehousing and Datamart within the Data Warehousing forums, part of the ERP category; Hello All, Could some one give me the practical difference between Data Warehousing and Datamart.... I would like to know ...


Go Back   Exforsys > ERP > Data Warehousing

Difference between Data Warehousing and Datamart Difference between Data Warehousing and Datamart

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 04-10-2006, 12:24 PM
Senior Member
  
Join Date: Jun 2004
Posts: 353
kalareddy is on a distinguished road
Difference between Data Warehousing and Datamart
Hello All,

Could some one give me the practical difference between Data Warehousing and Datamart.... I would like to know the answer with indistry related example..

Thanks.
Chandra
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-11-2006, 12:05 PM
Junior Member
  
Join Date: Dec 2005
Posts: 10
sriharid is on a distinguished road
n general a Data Warehouse is used on an enterprise level, while Data Marts is used on a individual department level . A data mart only contains the required subject specific data for local analysis
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-12-2006, 11:30 PM
Junior Member
  
Join Date: Apr 2006
Posts: 11
dwuser is on a distinguished road
DW vs Data mart vs Star Schema V/s Dimensional Model
Hello Friends,
You can understand all these concepts by downloading & studying book below:

http://www.redbooks.ibm.com/abstract...7138.html?Open

This is an excellent IBM Redbook on Data warehouse design and Dimensional Modeling design.

Great to read,
Dave
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Difference between Data Warehouse database and OLTP database | When you should consider Denormalization »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 05:33 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.