What are the advantages and disadvantages of having finest granularity data in the data warehouse and data marts?
Answers
Answered by
0
A data mart is focused on a single functional area of an organization and contains a subset of data stored in a Data Warehouse.
A data mart is a condensed version of Data Warehouse and is designed for use by a specific department, unit or set of users in an organization. E.g., Marketing, Sales, HR or finance. It is often controlled by a single department in an organization.
Data Mart usually draws data from only a few sources compared to a Data warehouse. Data marts are small in size and are more flexible compared to a Datawarehouse.
Similar questions