Oracle GoldenGate 11g Fundamentals for Teradata

Total time

Oracle GoldenGate 11g Fundamentals for Teradata

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, Oracle, CompTIA A+ / Network+ / Security+, IT Security, and Retail (Management).

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
Understanding Oracle GoldenGate Concepts
  • 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
Installing Oracle GoldenGate
  • Download the media pack
  • Installation on Windows
  • Installation on Linux and UNIX
  • Finding and Installing Oracle GoldenGate Documentation
Using Oracle GoldenGate Commands
  • 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
Configuring Oracle GoldenGate and Preparing the Environment
  • Configuration overview
  • Oracle GoldenGate Manager Process
  • Prepare Source Database for Replication
Configuring Change Capture - Maximum Performance
  • 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 Change Capture - Maximum Protection
  • 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
Configuring Initial Load
  • 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
Configuring Change Delivery
  • Explaining What the Replicat Process Does
  • Configuring and Starting a Replicat Process
  • Configuring Replicat to Handle Collisions Between Changes and the Initial Data Load
Examining Extract Trails and Files
  • Understanding Extract Trails and Files in Depth
  • Canonical Trail Format Overview
  • Understanding the LogDump Utility
  • Using LogDump to Troubleshoot Replication Issues
Understanding the Variety of Oracle GoldenGate Configuration Parameters
  • 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
Understanding Data Mapping and Transformations
  • 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
Mastering Additional Configuration Options
  • 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
  • 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
Managing Oracle GoldenGate
  • 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

There are no reviews yet.

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.