Re: Goldengate and DW

Those are two entirely different products with entirely different uses. You cannot do any sort of transformations with Dataguard, all you can do is take a copy of the data and put it into your standby database that may be open for read only, but is not open for read-write. Golden Gate allows you to copy data into a database that is open for read/write and a allows you to transform the data into something more suitable for a data warehouse.

On Mon, Jan 13, 2020 at 1:18 PM Ram Raman <veeeraman_at_gmail.com> wrote:

> Listers,
>
> Can we consider GG (goldengate) for replication of our multi TB data
> warehouse. Anything nuances, surprises there? Between GG and Dataguard
> which one can be a better product.
> Licensing cost is NOT an issue.
>
> Thanks
> Ram
> --
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l