| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ETL architecture
Presumably the reason for centralising the ETL tool is to share it and save
on licensing costs. Unfortunately you will fight the performance / cost
battle. Obviously this depends on how much work the ETL server will be
doing, how evenly that will be spread out across the day, how complex the
ETL processes are, etc. You may find that the solution works perfectly
well - or you may not.
In terms of the network connection being 100MBit... How much other traffic is sharing that? If the servers are physically close it may even be practical to use a cross-over cable directly between them. If not you probably want a switch at least to cut the traffic down. We currently use gigbit ethernet directly between our app and db servers for performance, with 100 MBit cards connecting the rest of the world (figuratively speaking).
Of course you could also consider reducing traffic slightly by turning the ETL server into the Staging server for flat files if you have the capacity.
Hopefully the situation works out for you.
Mark.
paquette stephane
<stephane_paquette@ To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
yahoo.com> cc:
Sent by: Subject: Re: ETL architecture
root_at_fatcity.com
17/10/2002 12:48
Please respond to
ORACLE-L
I've never see that approach. Last spring, I've worked at a "rich" client where there was 23 Oracle consultants and Oracle Warehouse Builder was installed on several servers instead of being installed in a central fashion.
I agree that the ETL tool should drive the whole show.
As for the network between the servers I think it's 100 megabits.
-- 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). <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: mrichard_at_transurban.com.au 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 - 23:23:35 CDT
 |
 |