Re: Creating a data warehouse.

Hi Louis,

If you are looking for an ETL tool, I would also examine DataMirror's Transformation Server. DataMirror Transformation Server is a high-performance peer-to-peer data integration tool that enables you to build things like real-time datawarehouses. That said, Transformation Server natively supports DB2 UDB on OS/390 (among other databases/platforms including Oracle, SQL Server, Sybase on OS/390, UNIX, Linux, AS/400, NT ...). DataMirror Transformation Server received top-honours in a ranking by Meta Group (Spex Research) a while back for ETL. More product information is available on our web-site (http://www.datamirror.com).

Hope this help
Amy Stearns

"LVF" <lisalou1_at_mediaone.net> wrote in message news:<mhUc7.34154$bm5.13192706_at_typhoon.ne.mediaone.net>...
> 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 Tue Aug 21 2001 - 09:44:34 CDT