Oracle GoldenGate (OGG) OverviewDescribe OGG functional overview and common topologiesDescribe OGG Veridata and Management Pack functionalityDescribe the difference between real-time data integration replication and Data Manipulation Language (DML) replicationArchitecture OverviewDescribe OGG componentsCreate the two types of Capture processes for Oracle databaseCreate the three types of Replicat processesExplain the difference between an Extract and Pump, and local and remote trailsConfigure OGG's process recovery mechanismInstall and Configure OGGDownload and Install OGG, and differentiate between various installers (zip, OUI, tar)Synchronize source and target databases with the Initial LoadPrepare database for OGG CDC and check databases with OGG schema check scriptConfigure OGG Replication component parameter filesConfigure the OGG Command Interface to create OGG processesDescribe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutionsConfigure OGG utilitiesParametersDescribe and compare GLOBALS versus MANAGER parametersCreate solutions using component parameters for replication requirementsInstall OGG parametersExplain and identify parameters specific for non-Oracle databasesMapping and Transformation OverviewImplement use cases for transformation functionsImplement macrosConfiguration OptionsDescribe OGG configuration options (Data Definition Language (DDL), compression and encryption options)Configure OGG event actions bas
What you'll learn
understand the functional overview and common topologies of Oracle GoldenGate
differentiate between real-time data integration replication and DML replication
install and configure Oracle GoldenGate
create and manage Capture and Replicat processes
implement data transformation functions and macros