Search Colleges, Exams, Schools & more
Login
Corporate Lawyers Ethics Regulation and Purpose
Online
3 Weeks
Free Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | University of Birmingham, Birmingham |
The Syllabus
- Uses of Oracle GoldenGate
- Reviewing Oracle GoldenGate Use Cases
- Oracle GoldenGate Use-Cases for Oracle Database
- Technology Overview
- Topologies
- Supported Platforms
- Supported Databases
- Oracle GoldenGate Technology Suite
- The Two Oracle GoldenGate Architectures
- Classic Architecture
- Extracts
- Initial Loads
- Checkpoints
- The Interaction Between Oracle GoldenGate and Oracle RDBMS
- Listing System Requirements
- Performing Installation
- Configuring Environment Variables
- Using Oracle GoldenGate Software Command Interface (GGSCI)
- Running Oracle GoldenGate from the OS shell.
- Use Obey files to automate tasks
- Configuration Overview
- Preparing the Environment
- Enabling Oracle GoldenGate in the Database
- Enabling Supplemental Logging
- Defining Roles and Permissions
- Starting the Manager
- Configuring Data Capture
- Initial Load Overview
- Configuring Initial Load
- Setting Up the Initial Load by Using the “File to Replicat” Method
- Setting Up the Initial Data Load by Using the “Direct Load” Method
- Replicat Overview
- Configuring Replicat Tasks
- Adding Checkpoints
- Using Checkpoints
- Initial Load: Avoiding Collisions with Initial Load
- Initial Load: Handling Collisions with Initial Load
- Troubleshooting: GGSCI Process Information
- Troubleshooting: Report FIles and Log Files
- Trail Format: Local and Remote
- Trail Format: Cleanup
- Trail Format: Record Header Area
- Trail Format: Record Data Area
- Alternative Trail Formats: Logical Change Records (LCRs)
- logdump: Opening, Viewing, and Filtering
- GLOBALS
- Manager
- Source Manager Parameters
- Target Manager Parameters
- Extract
- Extract Parameters on the Source Database
- Replicat
- Options Common to Both Replicat and Extract
- Mapping and Manipulation
- Definition Files
- Data Selection
- Where
- Filter
- Mapping
- SQLEXEC
- Pictorial view
- Configurations
- Data looping’s
- Resolving conflicts
- Effect of Oracle Sequences
- Overview of data mapping and manipulation
- Deciding where data mapping and conversion will take place Data Selection and Filtering
- Data Transformation
Articles
23 Sep'23, 04:38 PM
23 Sep'23, 04:38 PM