Oracle GoldenGate 11g Fundamentals for Teradata
Starting dates and places
Description
The Oracle GoldenGate 11g Fundamentals for Teradata course focuses on Teradata-to-Teradata data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances. The material presented in the lessons is complemented with hands-on lab practices, which guide the participants through exercises of…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
The Oracle GoldenGate 11g Fundamentals for Teradata course focuses on Teradata-to-Teradata data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances. The material presented in the lessons is complemented with hands-on lab practices, which guide the participants through exercises of increasing complexity until the subject matter is mastered by all participants.
Learn To:- Install Oracle GoldenGate software
- Configure Oracle GoldenGate for Teradata-to-Teradata replication
- Master Oracle GoldenGate utilities
- Perform data transformation
- Configure and manage Oracle GoldenGate instances
- Describe Oracle GoldenGate architecture
This course is based on Oracle Golden Gate version 11.1.1.
Audience
- Database Administrators
- Architect
- Database Designers
- System Integrator
Course Topics Learning Oracle GoldenGate Solutions
- What is Oracle GoldenGate?
- Oracle GoldenGate Use Cases
- Oracle GoldenGate Topologies
- Oracle Management Pack for Oracle GoldenGate
- Role of the Vendor Access Module (VAM) and Teradata Access Module (TAM)
- Teradata Capture and Delivery Methods
- Contrast maximum protection mode and maximum performance mode
- Describe how GoldenGate uses checkpointing to allow recovery
- Describe GoldenGate parameters, process groups and commands
- Download the media pack
- Installation on Windows
- Installation on Linux and UNIX
- Finding and Installing Oracle GoldenGate Documentation
- Get help information on GGSCI commands
- Identify the types of GGSCI commands available
- Run GoldenGate commands, from the GGSCI prompt, obey files and OS shell
- Configuration overview
- Oracle GoldenGate Manager Process
- Prepare Source Database for Replication
- Configuring Oracle GoldenGate for Change Capture from Teradata Opting for Performance Over Reliability
- Configuring Oracle GoldenGate Maximum Performance Parameters
- Configuring Oracle GoldenGate Data Pumps
- Configuring Oracle GoldenGate for Change Capture from Teradata Opting for Reliability Over Performance.
- Configuring Oracle GoldenGate Maximum Protection Parameters
- Understanding why Oracle Recommends Maximum Protection
- Understanding how to perform initial data load (database synchronization)
- Initial Load Methods
- Database Vendor Specific Load Methods
- Oracle GoldenGate Synchronization Methods
- Advantages of GoldenGate Methods
- Explaining What the Replicat Process Does
- Configuring and Starting a Replicat Process
- Configuring Replicat to Handle Collisions Between Changes and the Initial Data Load
- Understanding Extract Trails and Files in Depth
- Canonical Trail Format Overview
- Understanding the LogDump Utility
- Using LogDump to Troubleshoot Replication Issues
- Editing Parameter Files for Extract and Replicat Processes
- Comparing and Contrasting GLOBALS with Process Parameters
- Mastering Commonly-Used Parameters for GLOBALS, Manager, Extract and Replicat Processes
- Selecting and Filtering Data for Replication
- Using Column Mapping
- Interacting Directly with the Database through the Use of SQLEXEC
- Using Macros, Tokens and User Exits to Enrich Data Transformation
- Using BATCHSQL to Speed Delivery
- Using Data Compression Across the Network
- Using Message, Trail and Password Encryption
- Using Event Records to Automatically Trigger Actions
- Handling Bidirectional Issues, Such as Loop Detection, Conflict Detection and Teradata Identity Columns
- Understanding DDL Replication Concepts
- DDL Replication Requirements and Restrictions
- DDL Scopes
- DDL Parameters
- DDL String Substitution
- Error Handling
- DML Statement Shipping
- Eligibility Criteria for Statement Shipping
- Understand the Management Facilities Available in Oracle GoldenGate
- Automating Process Startup
- Managing Trail Files
- Handling TCP/IP errors
- Reporting and Interpreting Replication Statistics
- Monitoring Processes, Lags and Error Messages
- Learning How to Obtain Technical Support
Course Objectives
- Use Oracle GoldenGate for Teradata Utilities
- Perform Data Transformation Using Oracle GoldenGate
- Run and Manage Oracle GoldenGate Instances
- Describe Oracle GoldenGate Solutions
- Describe Oracle GoldenGate Architecture
- Install Oracle GoldenGate Software on Windows and Linux
- Configure Oracle GoldenGate for Teradata-to-Teradata Data Replication
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.