Advertisement
ctrlvfailed

Data Warehouse / Data Mart

Jan 17th, 2020
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. a data mart is a data warehouse that serves the needs of a specific team or business unit, like finance, marketing, or sales. It is smaller, more focused, and may contain summaries of data that best serve its community of users.
  2.  
  3. Data Warehouse
  4. Centralized, multiple subject areas integrated together.
  5. Organization wide.
  6. Many sources.
  7. Large, can be 100's of gigabytes to petabytes.
  8. Top - Down.
  9. Complete, detailed data.
  10.  
  11. Data Mart
  12. Decentralized, specific subject area.
  13. A single community or department.
  14. A single or a few sources, or a portion of data already collected in a data warehouse.
  15. Small, generally up to 10s of gigabytes.
  16. Bottom - Up.
  17. May hold summarized data.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement