From: TurkBear Newsgroups: comp.databases.oracle.server Subject: Re: Creating a data warehouse. Date: Wed, 08 Aug 2001 14:00:36 -0500 Reply-To: See Message body for real address Message-ID: References: <3g0c7.28883$bm5.10810721@typhoon.ne.mediaone.net> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 43 X-Authenticated-User: turkbear X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeeds.com http://www.newsfeeds.com 90,000+ UNCENSORED Newsgroups. There are many tools out there to help in Warehouse Building besides Oracle's rather late entry into the field.. Do a search for ETL tools ( Extract, Transform and Load )... My choice would be Ascential Software's DataStage XE ( http://www.ascentialsoftware.com/products/datastage/index.html ) but your results may vary.. "LVF" wrote: >Greetings all, I was hoping that someone might help me out. I am about to >embark on the >creation of a data warehouse and I am not quite sure were to start. I >understand the principles >behind the physical architecture of an Oracle database to house the ware >house. However, I am >not sure what I need to do next? I have an OLTP database which currently >has the data to that >needs to be warehoused. I have a test database created for the warehouse. >From what I can >see I think that I need Oracle's database warehouse builder, is this >correct? I would appreciate any >advice. I have read Kimball's book as well as Dodge's book, I fully >understand the philosophy and >theory behind the warehouse, my only problem is the initial "... how do I >get it going..."? > >Thank You, >Louis. > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----