Re: Creating a data warehouse.

I thank you for all your input. It sounds like the process of building the warehouse
is far more involved than the technology that implements it. FYI, I am running
Oracle9i Enterprise edition. My transactional database has about 1 Gig of data
in it. I will research further the methods of building out a data wareshouse.

Regards, Louis.

"LVF" <lisalou1_at_mediaone.net> wrote in message news:fUDc7.31645$bm5.12480205_at_typhoon.ne.mediaone.net...
> 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 Fri Aug 10 2001 - 11:50:26 CDT