Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support


GoldenGate

overview

Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.GoldenGate's complementary product accelerates Oracle's product strategy to manage real-time data integration through a comprehensive data integration platform. This combination is expected to deliver the fastest and most scalable real-time data integration solution for customers.
prerequisties
  • Familiarity with Oracle Database.
Duration
Online
  • It is a 16 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 4 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction
    • Discussing Required versus Suggested Knowledge
    • Listing Course Objectives
    • Discussing Course Non-Objectives (available as other follow-on courses)
  • Technology Overview
    • Creating Oracle GoldenGate Topologies
    • Reviewing Oracle GoldenGate Use Cases
    • Assembling Building Blocks
    • Listing Supported OS
    • Listing Supported Databases
    • Listing the Oracle Goldengate 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
    • 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
  • 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)
    • Reviewing Replicat Overview
    • Configuring Replicat Tasks
    • Configuring a Sample Environment
  • 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
    • 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
  • Additional Transformation Concepts
    • Configuring and Using Macros
    • Configuring and Using User Tokens
    • Configuring and Using User Exits
    • Configuring and Using Oracle Sequences
  • Configuration Options
    • Configuring and Using BATCHSQL
    • Configuring and Using Compression
    • Configuring and Using Encryption
    • Configuring and Using Event Actions
  • 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
Videos
For Videos Click Here Videos

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings