
After completing this module you will be able to understand
Differences between ETL approach and ELT approach
After completing this module you will be able to understand you will be able to understand what is oracle data integrator
After completing this module you will be able to understand
What is ODI Studio?
What are the 4 graphical components of ODI ?
What is Designer?
What is Operator?
What is Topology?
What is Security?
What are repositories?
What is Master Repository?
What is Work Repository
After completing this module you will be able to understand
What is the difference between Master Repository and Work Repository?
The scripts and files are used in lab environment
Please download scripts and files from downloadable materials and run the scripts with sysdba user privilize.
Flat Files and xml files can be copied to any folder.
After completing this module you will be able to understand
How to create schemas in Oracle database for ODI Repositories?
After completing this module you will be able to understand
How to create Master Repository with help of ODI Studio?
After completing this module you will be able to understand
How to create a connection to existing master repository in ODI studio?
After completing this module you will be able to understand
How to create a Work Repository using ODI Studio?
After completing this module you will be able to understand
How to attach newly created work repository to an existing master repository?
After completing this module you will be able to understand the following
Overview of 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
After completing this module you will be able to understand
How to hide unused technologies in topology navigator?
After completing this module you will be able to understand
What is a Model?
Understanding Metadata in ODI
Understanding Reverse Engineering
Creating Models
Organizing Models
Creating Data stores
After completing this module you will be able to understand
How to Explore Your Data
After completing this module you will be able to understand
How to Explore Your Data
After completing this module you will be able to understand
Overview of ODI Projects
Creating a New Project
After completing this module you will be able to understand
What are knowledge modules in ODI?
After completing this module you will be able to understand
What are the different knowledge modules in ODI?
After completing this module you will be able to understand
What to import the knowledge modules into project?
After completing this module you will be able to understand
Business Rules for Interfaces
What is a Mapping, Filter, Join?
Overview of Integration Process
After completing this module you will be able to understand
Creating a Basic Interface
Designing an Interface
Integration knowledge module (IKM) overview
Using Knowledge Modules (KM) with ODI Interface
Setting knowledge module option Flow control to False
Executing the interface
Operator Overview
Viewing the session log in operator
Exploring the code in operator
Creating simple mappings
Setting knowledge module option Truncate to True
After completing this module you will be able to understand
Monitoring Interfaces
Using Operator
Viewing Sessions and Tasks
How to Monitor Execution of an Interface
How to Troubleshoot a Session
Keys to Reviewing the Generated Code
After completing this module you will be able understand
How to create a simple filter transformation in ODI?
After completing this module you will be able understand
How to create a different filter transformations in ODI?
After completing this module you will be able understand
How to create a Advanced filter transformation in ODI?
After completing this module you will be able understand
How to create a Inner Join transformation in ODI?
After completing this module you will be able understand
How to create a data store by duplicating existing data store?
How to set the IKM knowledge module option Create Target table to True?
How to create a Left outer Join transformation in ODI?
After completing this module you will be able understand
How to create Right outer join transformation in ODI?
After completing this module you will be able understand
How to create Between join transformation in ODI?
After completing this module you will be able understand
How to create self join transformation in ODI?
After completing this module you will be able understand
How to create Union transformation in ODI?
After completing this module you will be able understand
How to create Union All transformation in ODI?
After completing this module you will be able understand
How to create Minus transformation in ODI?
After completing this module you will be able understand
How to create Intersect transformation in ODI?
After completing this module you will be able understand
How to create Rows to columns transformation in ODI?
After completing this module you will be able understand
How to create Columns to Rows transformation in ODI?
After completing this module you will be able understand
What are lookups?
How to create Left outer join Lookup transformation in ODI?
How to create Sql in from clause Lookup transformation in ODI?
Overview:
What You will learn:
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.
This offering details on how to use Oracle Data Integrator (ODI) 11g to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI 11g graphical user interfaces that enable user to access different ODI 11g components and resources that form ODI 11g infrastructure. Using the graphical interfaces, you create and manage ODI 11g repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI 11g Topology, organize ODI 11gmodels and design ODI 11g interfaces, procedures, packages and other objects.
Oracle Data Integrator (ODI) 11g is Oracle’s strategic tool covering all your data integration requirements. ODI 11g lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI 11g as a powerful tool for data integration solutions, it’s time you started making the most of it.
16 key Reasons to buy this course:
1. 24/7 Course Access for lifetime
2. As interactive as Classroom training
3. Very Cost effective
4. Advanced way of teaching
5. In depth explanation of each topic
6. Contains Hands on sessions
7. Any New module will be without additional charge
8. No travel and Hassel
9. Learn as per your comfort
10. Real time scenarios Hands on
11. Practice at Home using Virtual Machine
12. Free installation of ODI 11g software in your laptop
13. 100% Support will be provided to practice the Hands on's
14. More than 50 videos as on date (08-04-2014).
New videos will be added every week
15.Covers complex scenarios to aim ODI 11g certification
16. Covers most of the scenarios from ODI 11g blogs