Answer Detail: RE: 1).briefly state different between data ware house...

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: 1).briefly state different between data ware house & data mart?

2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?
3).What is meta data?

September 09, 2006 11:42:16	#5
OM PRAKASH BANG	Microsoft Expert Member Since: March 2006 Total Comments: 46
RE: 1).briefly state different between data ware house...
Datamarts are subset of Datawarehouse. Datamarts are departmental datawarehouse, whereas datawarehouse is enterprise datawarehouse. In bottom up approach of DWH, central metadata repository is created and datamarts are built with that... There are two types of Datamarts 1. Dependent Datamart 2. Independent Datamart

Back To Question