Re: datawarehouse extraction, snapshots?

From: sg <s4v4g3_at_europe.com>
Date: Thu, 15 Aug 2002 20:15:30 +0200
Message-ID: <3D5BEFC2.3070800@europe.com>

ah I forgot to mention version

8.1.6 at source
8.1.7 at destination

Tru64 platform

Jusung Yang wrote:

> You may be in luck. Look up ORACLE Change Data Capture (CDC) - if you
> are using 9i. CDC is specifically designed with ETL in mind. It is
> based on a publish-subscribe model. My limited testing showed it is
> quite easy to use. You only have to deal with a handful of ORACLE
> packages. How much overhead it places on your data source and if it is
> appropriate for your environment, you will have to find out for
> yourself.
>
Received on Thu Aug 15 2002 - 13:15:30 CDT