Live presentation of theory, demonstration of tool, features & tasks
We are connecting Online via Goto Meeting
Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern
Learn as per day-wise & customized schedule with discussions & lab exercises included
One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes
World-class learning material & case studies for the course
Completely customizable course content & schedule as per convenience
Certification guidance provided if necessary
Oracle Data Integration 12c Training
Course Overview:
Class: 1 Introduction to ODI
Identifying the Course Units
Why Oracle Data Integrator?
Overview of ODI Architecture
Overview of ODI Components
About Graphical Modules
Types of ODI Agents
Overview of Oracle Data Integrator Repositories
Class: 2 Installation of ODI 12c
Identifying the required software's.
Prerequisites
System Requirements
Installation of ODI
Repository Configuration using RCU
Setting the sample database for hands-on
Class: 3 Introduction to ODI Repository and Agents
Administrating the ODI Repositories
Connecting to the Master Repository
Connecting to the Work Repository
Managing ODI Agents
Creating a Physical Agent
Class: 4 ODI 12c Features
The Benefits of Using ODI 12c
Overview of ODI 12g Architecture and Components
The features of New ODI 12c User Interface and its Components
Overview of ODI 12g New Features
Class: 5 ODI Topology Navigator
Creating Physical Architecture
Creating a Data Server
Testing a Data Server Connection
Creating a Physical Schema
Creating Logical Architecture
Overview of Logical Architecture and Context Views
Linking the Logical and Physical Architecture
Class: 6 ODI Models and datastores
What is a Model?
Understanding Metadata in ODI
Understanding Reverse Engineering
Creating Models
Organizing Models
Creating Data stores
Configuring Constraints in ODI
Creating Keys and References
Class: 7 ODI 12c Mapping
What is a Mapping?
Designing a Mapping
Business Rules for Mapping
What is a Mapping, a Filter, a Join?
Overview of Integration Process
What is a Staging Area?
Execution Location
Mapping with Knowledge Modules (KM)
Creating an Intermediate Mapping
Class: 8 ODI 12c MappingMonitoring and Debugging
Monitoring Mappings
Creating Objects with Operator
Viewing Sessions and Tasks
How to Monitor Execution of a Mapping
How to Troubleshoot a Session
Keys to Reviewing the Generated Code
Working with Errors
Tips for Preventing Errors
Class: 9 Designing Mappings: 1
Mapping with Business Rules
Overview of Business Rule Elements
Creating and Tracking Variables
Creating User Functions
Mapping Substitution Methods
Showing Variable Values in Log
Customizing Reverse Engineering Using RKM
Class: 10 Designing Mappings: 2
Using Partitioning in a Mapping
Reusable Mappings
Derived Select (Subselect) for Reusable Mappings
Using User Functions
Creating a User Function
Using Substitution Methods
Class: 11 ODI Procedures
What is a Procedure?
Examples of Procedures
Creating Procedures
Adding Commands
Adding Options
Running a Procedure
Viewing Results with Operator
Class: 12 ODI Packages
What is a Package?
Creating a Package
Executing a Package
Creating Advanced Packages
Error Handling
Controlling an Execution Path
Creating a Loop
Class: 13 ODI Scenarios and versions
What is a Scenario?
Managing Scenarios with Load Plans
Preparing Scenarios for Deployment
Automating Scenario Management
Scheduling the ODI Scenario
Overview of ODI version management
Handling concurrent changes
Class: 14 Enforcing Data Quality
Why Data Quality?
When to Enforce Data Quality?
Data Quality in Source Applications
Data Quality Control in the Integration Process
Data Quality in the Target Applications
Enforcing Data Quality
Exploring Your Data
Auditing Data Quality
Class: 15 ODI Changed Data Capture
Techniques of Changed Data Capture
Changed Data Capture in ODI
CDC Strategies and Infrastructure
CDC Consistency
Creating Change Data Capture (CDC)
Viewing Data/Changed data
Journalizing
Class: 16 Load Plans
What Are Load Plans?
Load Plan Editor
Load Plan Steps
Defining the Restart Behavior
Benefits of Using Load Plans
Handling Failed Load Plans
Class: 17 ODI Security Navigator
Security Concepts: Overview,
Defining Security Policies
Creating Profiles, Creating Users,
Assigning a Profile to a User,
Assigning an Authorization by Profile or User
Defining Password Policies,
Generating Topology Reports
Class: 18 Step-by-Step Debugger
Benefits of Using Step-by Step Debugger
Overview of the Features of Step-by-Step Debugger
Debugging Mappings using the Debugger
Debugging Packages using the Debugger
Class: 19 Developing ODI Knowledge Modules
Overview of Different Types of KMs
Guidelines for KM Developers
Working with Substitution Methods
Applying Various ODI Tags
Implementing Java in KMs
Troubleshooting and Debugging KMs
Class: 20 Using Groovy in ODI
Interacting Programmatically with ODI
Overview of ODI SDK
Introduction to Groovy
Using Groovy Editor
Automating Development Tasks with Groovy
DBA,
Students who want to make their career in database
basic knowledge of SQL and relational database
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Live Interactive classes with expert
Question: Can I attend the Demo session before enrollment?
Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion
Question: Can you schedule the training based upon my availability?
Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.
Question: How I can pay for the course?
Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.
Question: What if I missed any class?
Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.
Question: Is there any live project training along with regular training?
Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.
Question: What about certification preparation and guidance?
Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.
Question: Who is the trainer & about his experience?
Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.
Question: Do you provide Job support?
Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com
Question: What if I have more queries and doubts?
Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com
Question: How Fee Refund Policy works?
Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy
Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.
We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.