in Others retagged by
1 vote
1 vote

A data mart may contain

  1. Summarised data
  2. De-normalized data
  3. Aggregate departmental data
  4. All of the above
in Others retagged by

1 Answer

3 votes
3 votes
Best answer

ans should be D 

Datawarehouses are huge. If a department has its own data mart, it can customize the data as the data flows into the data mart from the data warehouse. It can summarize,sort,select and structure its own data.

Data mart vs data warehouse[edit]

Data warehouse:

  • Holds multiple subject areas
  • Holds very detailed information
  • Works to integrate all data sources
  • Does not necessarily use a dimensional model but feeds dimensional models.

Data mart:

  • Often holds only one subject area- for example, Finance, or Sales
  • May hold more summarized data (although many hold full detail)
  • Concentrates on integrating information from a given subject area or set of source systems
  • Is built focused on a dimensional model using a star schema.

selected by

Related questions