Re: Creating a data warehouse.

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" <lisalou1_at_mediaone.net> 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! =----- Received on Wed Aug 08 2001 - 14:00:36 CDT