Data Mart - sachit914/datawarehouse GitHub Wiki

what is data mart

  • a datamart is a subset of a data warehouse that is focused on a specific subject area or department within an organization.Data Mart tailored to the needs of a particular business unit

image

  • from datawarehouse we create a small sunset of datamart for finacial activities , for sales team , for analytics team
  • all these data mart are for specific data needs

characteristic of datamart

  • highly specific subject area
  • subset of larger dataWAREHOUSE WITH PARTICULAR BUSINESS USER AND SPECIFIC DATES
  • often involves summarized data drom datawarehouse
  • more control to business- fast query performance

types of datamart

  • dependent data mart

  • data mart is dependent on datawarehouse,if data warehouse is not there then there wont be data mart

  • independent dataMart fetching data directly from data source and creating data mart image