Re: Datawarehouse->(ETL)->Datamart; Where should ETL be physically located?
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Thu, 18 Mar 2010 08:03:57 -0700 (PDT)
Message-ID: <6655d24b-ac6a-433d-ab60-43086b127ba3_at_19g2000yqu.googlegroups.com>
On Mar 18, 11:29 am, guser78 <qazmlp1..._at_rediffmail.com> 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?
Date: Thu, 18 Mar 2010 08:03:57 -0700 (PDT)
Message-ID: <6655d24b-ac6a-433d-ab60-43086b127ba3_at_19g2000yqu.googlegroups.com>
On Mar 18, 11:29 am, guser78 <qazmlp1..._at_rediffmail.com> 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