Re: Datawarehouse->(ETL)->Datamart; Where should ETL be physically located?

From: Carlos <>
Date: Thu, 18 Mar 2010 08:03:57 -0700 (PDT)
Message-ID: <>

On Mar 18, 11:29 am, guser78 <> wrote:
> 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?

"Should it be part of 'Data warehouse' box, or the 'Datamart' box?"

Neither of them. It should be on a separate ETL server with the ETL tools and processes installed on it (and a lot of free HD space too).

HTH. Cheers.

Carlos. Received on Thu Mar 18 2010 - 10:03:57 CDT

Original text of this message