Re: Oracle Warehouse Builder Installation

In article <8q4mr9$7qu$1_at_nereid.worldonline.nl>,   "Peter" <P.Slingerland_at_IMN.nl> wrote:
> <arthuryung_at_my-deja.com> wrote in message
> news:8q4ja3$ocf$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I am installing OWB(Oracle Warehouse Builder). I found it will
 install
> > a repository database and a runtime repository database. Do I need
 to
> > have 2 seperate database for them, or I can have them in the same
> > database??
> >
> > Btw, what is the different between these two repository database??
> >
> > Thanks,
> > Arthur
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Hi Arthur,
>
> If you aim to use this installation not just for evaluation purposes,
 you
> should install the
> repositories in different instances.
> The OWB repository is the repository where all your models,
 transformation
> rules etc are
> stored (like a Oracle Designer repository). The run-time repository
 is a set
> of tables and
> packages used during an actual ETL process run. These tables and
 packages
> are used
> by OWB generated code for your data transformation (like a run-time
> environment).
> I would create a seperate instance for the OWB repository, and
 include the
> run-time
> repository in a current development/test/production data warehouse
 instance
> if you already
> have one, or create a new database instance if not.
>
> Peter.
>
>

In fact, is the data loaded into the run-time repository database and I have to make sure its size is large enough for the data growth?

Rgds,
Arthur

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 20 2000 - 00:00:00 CEST