When GoldenGate is used in some of the topologies where the source and target systems are not identical, you would most likely be required to perform some additional configuration. GoldenGate has got many additional parameters and options using which you can set up complex mappings and filtering. Data Lifecycle management is becoming an important part of the overall IT strategy of various companies. The regulatory requirements in some industries require the businesses to maintain a record of upto seven years or even longer. In such cases if you keep all the data in main database tables it can cause performance problems. Using GoldenGate you can track the changes applied on a table to maintain a transaction history without much impact on the production system. It also allows you to track the replication errors using exception handling.

Using GoldenGate macros, you can write the process configuration parameters once and reuse them in multiple parameter files in a single environment...