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 [EMAIL PROTECTED] __________________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).