Is this a Data warehouse or a Datamart???

It depends....

There are two schools of thought here.

1) As per Ralph Kimball, Data warehouse comprises of various data marts. Each data mart will be a part of the data warehouse. Here is the pictorial view of a data warehouse as per Kimball methodology.


We have only one datamart, so in our case this is a Data warehouse as well as a Datamart.


 2)  As per Inmon, Data warehouse is the source of various datamarts.


In our case, as we have no separate Data warehouse built to derive the datamart, we have only a Datamart but not a Data warehouse.


No comments:

Post a Comment