Datamart is something which consists of only ONE type of DATA whereas datwarehouse consists of data of different type.For example all the ORGANISATION data say data related to finance DEPARTMENT,HR,Banking dept are stored in datawarehouse whereas in datamart say only finance data will stored.So datawarehouse is a collection of different datamarts.

A data mart is a subject oriented database which supports the business needs of individual departments within the enterprise.It is an subset of the enterprise data warehouse.It is also known as high performance query STRUCTURES.

Datamart is something which consists of only one type of data whereas datwarehouse consists of data of different type.For example all the organisation data say data related to finance department,HR,Banking dept are stored in datawarehouse whereas in datamart say only finance data will stored.So datawarehouse is a collection of different datamarts.

A data mart is a subject oriented database which supports the business needs of individual departments within the enterprise.It is an subset of the enterprise data warehouse.It is also known as high performance query structures.