Hi, I'm wondering what are the differences in using materialized view and Oracle Golden Gate for pulling data from source(s) to target(s) database and vice versa, what are best cases to use one over the other, advantages and disadvantages.
I'm implementing Goldengate as a standard way of pulling data, but the people who I work with already have materialized views for pulling data, and they are asking why go through Oracle Golden Gate if we already have something working? why to change ?