Data Warehouse Architecture (with a Staging Area and Data Marts)

We can do this by adding data marts, which are systems designed for a particular line of business. For example where purchasing, sales, and inventories are separated. In this example, a financial analyst might want to analyze historical data for purchases and sales

Data Warehouse Architecture (with a Staging Area)

We need to clean and process our operational data before putting it into the warehouse. So we can do this programmatically, although most data warehouses use a staging area instead. A staging area simplifies building summaries and normal data warehouse management

Difference between Data Warehouse & Data Mart

DATA WAREHOUSING Focuses enterprise level, With different Subject.
Example : IN LIC
we have loan & Insurance, for both of these if we create Data Warehouse then it is said to be Data Warehousing

DATA MART Focuses singal line of business.

Example : IN LIC
if we create separate Data Warehousing for both these, then it is said to be Data Mart.
Data Mart is sub set of DataWarehosuing