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
- 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
- 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