What is the difference between a data warehouse and a data mart?
Submitted by: AdministratorDatamart 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Data Warehouse Data Mart Job Interview Questions And Answers
Top Data Warehouse Data Mart Questions
☺ | Explain What is data validation strategies for data mart validation after loading process? |
☺ | What is data mart? |
☺ | Explain What are Data Marts? |
☺ | Explain difference between data ware house & data mart? |
☺ | What is difference between drill & scope of analysis? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |