Re: Datawarehouse->(ETL)->Datamart; Where should ETL be physically located?
From: guser78 <qazmlp1209_at_rediffmail.com>
Date: Fri, 19 Mar 2010 02:32:07 -0700 (PDT)
Message-ID: <500744c2-166f-4476-9ce4-305a38f32768_at_e7g2000yqf.googlegroups.com>
On Mar 18, 8:03 pm, Carlos <miotromailcar..._at_netscape.net> wrote:
> 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).
Date: Fri, 19 Mar 2010 02:32:07 -0700 (PDT)
Message-ID: <500744c2-166f-4476-9ce4-305a38f32768_at_e7g2000yqf.googlegroups.com>
On Mar 18, 8:03 pm, Carlos <miotromailcar..._at_netscape.net> wrote:
> 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).
I agree with that. But, what do you do when you have the option of having only 2 physical servers (1->DWH, 1->Datamart, ETL:where?)? Received on Fri Mar 19 2010 - 04:32:07 CDT