Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Trainings
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Oracle GoldenGate enables exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across an enterprise. Its modular architecture provides flexibility, filtering, transformation and custom processing features of Oracle GoldenGate. Oracle GoldenGate supports numerous business requirements, such as, initial load and database migration, data integration, decision support and data warehousing. Customers can achieve continuous availability for critical systems and real-time data integration, required for swift access to current and accurate data.

Preview

By the end of this training you will learn to:

  • Install Oracle GoldenGate on Linux and Windows platforms
  • Issue GGSCI commands
  • Configure, start, stop, and monitor Change Capture and Delivery processes
  • Manage Extract trails and files using Data Pump and logdump
  • Create parameter files to transform data
  • Manage multiple Oracle GoldenGate instances

Course Contents

Day 1

 

Technology Overview

 Creating Oracle GoldenGate Topologies

Reviewing Oracle GoldenGate Use Cases
Assembling Building Blocks
Listing Supported OS
Listing Supported Databases
Listing the Oracle GoldengGate Product Line
Describing GUI Management Options
Listing Non-Database Sources and Targets
Oracle GoldenGate Architecture

Describing Oracle GoldenGate Process Groups

Explaining Change Capture and Delivery (with and without a Data Pump)
Explaining Initial Data Load
Contrasting Batch and Online Operation
Explaining Oracle GoldenGate Checkpointing
Describing Commit Sequence Numbers (CSN)
Describing Oracle GoldenGate Files and Directories
Installing Oracle GoldenGate


Day 2

Listing System Requirements

Performing Installation
Configuring Environment Variables
Using GGSCI
Running Oracle GoldenGate from the OS shell.
Configuration Overview and Preparing the Environment

Reviewing Configuration Overview

Configuring Manager Process
Creating Source Definitions
Preparing the Source Database
Assigning Oracle Database Roles/Privileges Required
Using DBMS_GOLDENGATE_AUTH Package
Configuring Change Capture (Extract)

Reviewing Extract Overview

Accessing Logs on Oracle ASM
Accessing Logs Remotely
Configuring Extract Tasks
Adding Extract Group
Editing Extract Parameters
Extracting Use of Archived Transaction Logs
Adding Trails
Configuring Change Delivery (Replicat)


Day 3

Reviewing Replicat Overview

Configuring Replicat Tasks
Configuring a Sample Environment
Configuring New Integrated Replicat
Configuring Extract Trails and Files (Data Pump)

Reviewing Extract Trails and Files Overview

Describing Trail Formats
Using Logdump for Viewing Trails
Reversing the Trail Sequence
Configuring and Using Data Pumps
Performing Initial Load

Oracle GoldenGate Methods

Listing Database-specific Methods
Describing Resource Limitations
Listing Advantages of Oracle GoldenGate Methods
Configuring File Load Methods
Configuring Direct Load Methods
Handling Collisions with Initial Load
Editing Configuration Parameters


Day 4

Editing Parameter Files

Contrasting GLOBALS versus Process Parameters
Configuring GLOBALS Parameters
Configuring Manager Parameters
Configuring Extract Parameters
Configuring Replicat Parameters
Filtering and Data Selection

Filtering and Data Selection

Mapping Columns Between Different Schemas
Using Built-in "@" (at) Functions
Using SQLEXEC to Interact Directly with a Database
Configuring New Coordinated Replicat
Additional Transformation Concepts

Configuring and Using Macros

Configuring and Using User Tokens
Configuring and Using User Exits
Configuring and Using Oracle Sequences
Configuration Options


Day 5

Configuring and Using BATCHSQL

Configuring and Using Compression
Configuring and Using Encryption
Configuring and Using Event Actions
Configuring New Wallet Security
Bidirectional Replication

Reviewing Bidirectional Considerations

Detecting Loops
Avoiding Conflicts
Configuring and Using Conflict Detection and Resolution
Describing Identity Types Issues
DDL Replication

Reviewing Data Description Language Replication Overview

Configuring and Using Options for DDL Replication
Configuring and Using String Substitution in DDL


Enroll


Training Hours

Start Date:  02nd February 2019

Duration: 5 Days

Training Schedule: 02, 03, 09, 10 & 16th Feb 2019

Timing: 12:00 NOON GMT | 07:00AM EST | 4:00AM PST | 6:00AM CST | 5:00AM MST | 5:30PM IST  | 01:00PM GMT+1

 

Audience

  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Configuration Consultant
  • Technical Consultant



Training Administrator

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner