Oracle Golden Gate 11G Online Training

[cssadhar]

·         Introduction to Oracle Golden Gate 11g: Fundamentals for Oracle

·         Objectives

·         Oracle Golden Gate 11g

·         Key Capabilities & Technology Differentiators

·         Value Propositions for Oracle Golden Gate

·         Oracle Golden Gate Topologies

·         Oracle middleware for Business Intelligence

·         Oracle Data Integrator EE & Oracle Golden Gate

·         Oracle Golden Gate for Real-Time Data Warehousing

·         Oracle Golden Gate Solutions for Oracle Database

·         Oracle Golden Gate for Oracle Database Eliminate down Time for Migrations and Application upgrades

·         Oracle Golden Gate for Oracle Database Eliminate down Time during Oracle Database upgrades

·         Oracle Golden Gate for Oracle Database Eliminate up planned Down Time with Active Data Guard and Oracle Golden Gate

·         Oracle Golden Gate for Oracle Database Improve Production System Performance and Lower costs

·         Oracle Golden Gate for Operational Reporting

·         Oracle Golden Gate for Oracle Database Increase Returns on Investment on Existing Servers and Synchronize Global Data

·         Technology Overview

·         Objectives

·         Oracle Golden Gate: Modular Building Blocks

·         Supported Databases and Operating systems

·         Oracle Golden Gate Product Line

·         Oracle Golden Gate Veridata

·         Oracle Golden Gate Director: Overview

·         Oracle Golden Gate Monitor: Overview

·         Adapter Integration Options for Oracle Golden Gate

·         Oracle Golden Gate for Flat File

·         Oracle Golden Gate Application Adapter for Java

·         JMS Messaging Capture

·         Oracle Golden Gate Architecture

·         Objectives

·         Oracle Golden Gate Uses

·         Oracle Golden Gate Components

·         Oracle Golden Gate Logical Architecture

·         Oracle Golden Gate Process Groups

·         GGSCI

·         Parameter Files

·         Change Data Capture and Delivery

·         Change Data Capture and Delivery using a Data Pump

·         Running an Initial Load

·         Initial Load

·         Checkpoints

·         Check pointing

·         Commit Sequence Number (CSN)

·         Installing Oracle Golden Gate

·         Objectives

·         System Requirements

·         Operating System Requirements

·         Downloading Oracle Golden Gate

·         Installation on UNIX, Linux or Z/OS

·         Installation on Windows

·         Oracle Golden Gate Directories

·         Oracle Golden Gate Documentation

·         GGSCI Command Interface

·         GGSCI Commands

·         GGSCI Command Examples

·         OBEY Files

·         New Oracle Golden Gate 11g R1 GGSCI Miscellaneous Commands

·         Running Oracle Golden Gate from the OS Shell

·         Configuration Overview and Preparing the Environment 

·         Objectives

·         Configuring Oracle Golden Gate

·         Preparing the Environment: Oracle Database

·         Preparing the Environment: Manager Overview

·         Preparing the Environment: Configuring Manager

·         Preparing the Environment: Sample Manager Parameter File

·         Preparing the Environment: Overview of Source Definitions

·         Preparing the Environment: Running defgen

·         Configuring Change Capture

·         Objectives

·         Step 2: Change Capture

·         Extract Overview

·         Data pump Overview

·         Data pump: One-to-many Trails

·         Data pump: One-to-many Target Systems

·         Setting up Change Capture

·         Add Extract Command

·         Add Extract Examples

·         Editing Extract Parameters

·         Passive Alias Extract

·         Overview of Trails

·         Adding a Local or Remote Trail

·         Starting the Extract

·         Primary Extract Configuration for Oracle

·         Data pump Configuration for Oracle

·         Automatic Storage Management (ASM)

·         Ensuring ASM Connectivity

·         Configuring Initial Load

·         Objectives

·         Step 3: Initial Load

·         Initial Load: Advantages of Oracle Golden Gate Methods

·         Initial Load: Resource Limitations

·         Prerequisites for Initial Load

·         Initial Load: Oracle Golden Gate Methods

·         Initial Load: File to Replicate

·         Initial Load: File to Database Utility

·         Initial Load: Direct Load

·         Initial Load: Direct Bulk Load (to Oracle)

·         Configuring Change Delivery

·         Objectives

·         Step 4: Change Delivery

·         Replicate Overview

·         Change Delivery Tasks

·         Checkpoint Table

·         Sample Configuration

·         Avoiding Collisions with Initial Load

·         Handling Collisions with Initial Load

·         Extract Trail and Files

·         Objectives

·         Overview of Extract Trails and Files

·         Extract Trails and Files Distribution

·         Extract Trails and Files Contents

·         Extract Trails and Files Clean up

·         Trail Format

·         Record Header Area

·         Record Data Area

·         Setting the Compatibility Level

·         Alternative Trail Formats

·         FORMATASCII

·         FORMATASCII Sample Output

·         FORMATSQL

·         FORMATSQL Sample Output

·         FORMATXML

·         FORMATXML Sample Output

·         Log dump Utility

·         Opening a Trail

·         Setting up a View

·         Viewing the Trail file Header

·         Viewing Trail Records

·         Counting Records in the Trail

·         Filtering by a File name

·         Locating a Hex Data Value

·         Saving Records to a new Trail

·         Keeping a Log of Your Session

·         Overview of the Reverse Utility

·         Overview Process of the Reverse Utility

·         Reverse: Overview Process

·         Sample Parameter Files

·         Oracle Golden Gate Parameter

·         Objectives

·         Oracle Golden Gate Parameter Files

·         Using Parameter Files

·         Global versus Process Parameters

·         Global Parameters

·         Manager Parameters: Overview

·         Sample Manager Parameter File

·         Manager Parameter Categories

·         Extract Parameter Overview

·         Extract Parameter Defaults

·         Sample Extract Parameter File

·         Extract Parameter Categories

·         Extract Example: Table Parameter

·         Extract Example: Tranlogoptions Parameter

·         Replicat Parameter Overview

·         Replicat Parameter Defaults

·         Sample Replicat Parameter File

·         Replicat Parameter Categories

·         Replicat Example: MAP Parameter

·         Db options

·         Data Selection and Filtering

·         Objectives

·         Overview of Data Mapping and Manipulation

·         Types of Definition Files

·         Data Selection: Overview

·         Data Selection: WHERE Clause

·         Data Selection: WHERE Clause Examples

·         Data Selection: FILTER Clause

·         Data Selection: FILTER Clause Examples

·         Data Selection: RANGE Function

·         Data Selection: RANGE Function Example

·         Column Mapping: Overview

·         Column Mapping: Example

·         Column Mapping: Building H

 

 

Contact US:309-200-3848

·         @IF Functions

·         Functions: Working with Strings and Numbers

·         @STRCAT Function

·         @STREXT Function

·         Other Functions

·         Overview of SQLEXEC

·         SQLEXEC: Basic Functionality

·         SQLEXEC: DBMS and Data Type Support

·         SQLEXEC: Using with a LOOKUP Stored Procedure

·         SQLEXEC: Using with a SQL Query

·         SQLEXEC: Using within a TABLE or MAP Statement

·         SQLEXEC: Using as a Stand-Alone Statement

·         Additional Transformation Topics

·         Objectives

·         Overview of Macros

·         Creating Macros

·         Invoking a Macros

·         Reusing Parameter Sets

·         Creating Macros Libraries

·         Tracing Macro Expansion

·         Overview of User Tokens

·         Environmental Values Available to @ GETENV

·         User Tokens Display

·         Using User Tokens

·         Viewing User Exits in Log dump

·         Overview of User Exits

·         Uses for User Exits

·         User Exits: High-Level Processing Logic

·         Implementing User Exits