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

From: Nithyanandham M <>
Date: Fri, 19 Mar 2010 02:27:08 -0700 (PDT)
Message-ID: <>

On Mar 18, 8:03 pm, Carlos <> wrote:
> 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).

I agree with that. But, what do you choose when you have the option of having only 2 servers (1->DWH, 1->Datamart, ETL->where?)? Received on Fri Mar 19 2010 - 04:27:08 CDT

Original text of this message