Re: Goldengate and DW

Thanks everyone who responded.

"GG has a whole different set of rules and is, in my opinion, much better for creating a DW". I think I will go with GG, it looks like I will have the options to filter out part of the transactions during replication. Does GG have a big learning curve given I am only considering replicating over all the data to start with.

On Sun, Jan 19, 2020 at 9:17 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Ram, GG and DG are different products. Logical standby DB is still just a
> copy of the database, despite all of the dbms_logstdby.skip rules. GG, on
> the other hand, is just a database replication product. You can do
> symmetric replication, which is not something you can do with DG. GG has a
> whole different set of rules and is, in my opinion, much better for
> creating a DW.
> On 1/13/20 2:16 PM, Ram Raman 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
> --
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--

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