Re: ETL architecture

From: <Jared.Still_at_radisys.com>
Date: Wed, 16 Oct 2002 12:20:17 -0800
Message-ID: <F001.004EB3C0.20021016122017@fatcity.com>

This is a common approach.

Should be ok if:

• transporting the ftp files is part of the ETL process
• big fat pipe to the servers.

Jared

paquette stephane <stephane_paquette_at_yahoo.com> Sent by: root_at_fatcity.com
 10/16/2002 11:25 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        ETL architecture

Hi,

On all DW project I've been, the ETL tool was on the database server containing the DW database.

On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing.
We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is.
So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B.

Somewhere I'm not confortable with that approach. Any comments ?

---

Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com

---

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?paquette=20stephane?=   INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 16 2002 - 15:20:17 CDT