Golden Gate Online Training

GOLDEN GATE TRAINING provides the knowledge on Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability. GOLDEN GATE TRAINING objective of this training is to explain the fundamental concepts of Oracle Golden Gate used for data replication and integration. Oracle Golden Gate concepts will be explain by demonstration programs wherever required and possible on Oracle Database.

GOLDEN GATE TRAINING at Tysco Online Trainings by excellent experienced IT professionals. Our trainer has good training experience so that best quality output will be delivered. Regsiter today in the website for the best online GOLDEN GATE TRAINING or call us at help desk to know more details.

GOLDEN GATE ONLINE TRAINING COURSE CONTENT

GOLDENGATE OVERVIEW

  • Why GoldenGate
  • Listing Supported OS
  • Listing Supported Database
  • GoldenGate Topologies

ORACLE GOLDENGATE ARCHITECTURE

  • Oracle GoldenGate Process Groups
  • Capture & Delivery
  • Initial Data Load
  • Batch & Online Operation
  • Oracle GoldenGate Checkpointing
  • Commit Sequence Numbers (CSN)
  • Oracle GoldenGate Files and Directories

INSTALLING ORACLE GOLDENGATE

  • Listing System Requirements
  • Performing Installation
  • Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.

CONFIGURATION OVERVIEW & PREPARING THE ENVIRONMENT

  • Configuration Overview
  • Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required

CONFIGURING CHANGE CAPTURE (EXTRACT)

  • Extract Overview
  • Accessing Logs on Oracle ASM & Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails

CONFIGURING CHANGE DELIVERY (REPLICAT)

  • Reviewing Replicat Overview
  • Replicat Tasks
  • Sample Environment

CONFIGURING EXTRACT TRAILS AND FILES (DATA PUMP)

  • Extract Trails and Files Overview
  • Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring & Using Data Pumps
PERFORMING INITIAL LOAD

  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • File Load Methods
  • Direct Load Methods
  • Handling Collisions with Initial Load

EDITING CONFIGURATION PARAMETERS

  • Editing Parameter Files
  • GLOBALS versus Process Parameters
  • GLOBALS , Manager , Extract ,&   Replicat Parameters

FILTERING & DATA SELECTION

  • Mapping Columns Between Different Schemas
  • Built-in “@” (at) Functions
  • SQLEXEC to Interact Directly with a Database

ADDITIONAL TRANSFORMATION CONCEPTS

  • Macros
  • User Tokens
  • User Exits
  • Oracle Sequences

CONFIGURATION OPTIONS

  • BATCHSQL
  • Compression
  • Encryption
  • Event Actions

BIDIRECTIONAL REPLICATION

  • Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring &  Using Conflict Detection and Resolution
  • Identity Types Issues

DDL REPLICATION

  • Reviewing Data Description Language Replication Overview
  • Options for DDL Replication
  • String Substitution in DDL