Re: Datawarehouse->(ETL)->Datamart; Where should ETL be physically located?
From: Nithyanandham M <nithyan78_at_gmail.com>
Date: Fri, 19 Mar 2010 02:27:08 -0700 (PDT)
Message-ID: <956f313c-619f-459e-959a-2960c30db371_at_g26g2000yqn.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 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
Date: Fri, 19 Mar 2010 02:27:08 -0700 (PDT)
Message-ID: <956f313c-619f-459e-959a-2960c30db371_at_g26g2000yqn.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 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