Re: Creating a data warehouse.

Hey Thanks for the input. So what you are saying is that if I have an Oracle database configured for a data warehouse, Oracle data warehouse builder and an OLTP database full of transactional data I have all that is needed to build a warehouse?

L
"TurkBear" <noone_at_nowhere.com> wrote in message news:sp23nt44isba04e8h575h0dapv70bf35i6_at_4ax.com...
>
> 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 Thu Aug 09 2001 - 17:11:23 CDT