Experiences / Notes on Data Warehousing on 9iRAC on Linux

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 19 May 2004 22:18:12 +0800
Message-Id: <6.1.0.6.0.20040519221740.024ab1d8@pop.singnet.com.sg>

My organisation is planning to migrate the current DWH [8i on Solaris] to 9iRAC on Linux. The initial load will be 50GB, growing to 500GB in 6 months.

I am looking for notes / "how-tos" / tips / traps on implementing a DWH on 9iRAC on Linux.
Current extraction from the ODS is by combinations of FTP and PLSQL jobs. We would be looking at products like Ascential DataStage or BusinessObjects DataIntegrator
or the like for ETL and BusinessObjects WebIntelligence for Reporting/Querying.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 19 2004 - 09:17:08 CDT