Datawarehouse->(ETL)->Datamart; Where should ETL be physically located?
Date: Thu, 18 Mar 2010 03:29:49 -0700 (PDT)
In the 'Dependent Data mart' case, there is an ETL layer to extract the data from the central Data Warehouse to adapt and Load onto the 'Data mart'.
Assume that the 'Data warehouse' and 'Data mart' run on separate physical servers. In such a case, where does the ETL layer (which is used to load onto Datamart from Datawarehouse) fit better? Should it be part of 'Data warehouse' box, or the 'Datamart' box? Why? Received on Thu Mar 18 2010 - 05:29:49 CDT