|
ODI-12C Course Curriculum
Comparison: ETL Vs ELT
ETL Architecture overview
ELT Architecture Overview
ETL Vs ELT
Introduction to ODI
What is Oracle Data Integrator and why to use ODI ?
Overview of ODI 12C & ODI 11g Architecture, ODI 11g vs. ODI 12c and ODI 12c new features
Overview of ODI Components (Studio, Agent, Repository)
About Graphical Modules, ODI Agents and ODI Repositories
Administering ODI Repositories and Agents
Administrating the ODI Repositories. Creating Repository Storage Spaces
Creating and Configuring Master and Work Repositories
Managing ODI Agents and Creating a Physical Agent
Launching a Listener, Scheduler and Web Agent
DESIGNER : ODI Topology Concepts
ODI Studio connectivity to Repository, Overview of ODI Topology
Planning and Physical Topology overview
About Data Servers and Physical Schemas, Overview of Topology Navigator
Physical and Logical Architecture
Defining the Physical Architecture, Data Server and Testing connectivity
Creating Physical schema, configuring Oracle Database, files, XML files, Creating physical agent
Defining the Logical Architecture, Mapping Logical & Physical Resources, Define logical agents
Defining and planning of a Topology
Creating Logical Architecture, Overview of Logical Architecture and Context Views
Linking the Logical and Physical Architecture
Overview of ODI context, Global context, mapping physical logical schemas
ODI Project
Overview of ODI Projects, Creating and Organizing New Projects and Folders
Understanding Knowledge Modules, Exchanging ODI Objects and Sharing Global Objects
Exporting and Importing Objects. Using Markers
ODI Model Concepts
What is a Model? Understanding Metadata in ODI and understanding Reverse Engineering
Creating and organizing Models and Data stores, Using Constraints Keys and References in ODI
Organizing ODI Models and Creating Data stores
What is a Mapping how to create a mapping in ODI. ODI 12c mappings Vs ODI 11g interfaces
Business Rules for Mappings
Creating a Mapping using components : Join, Filter, Switch, Lookup, Aggregate, datasets, Distinct, Expression, Sort, Constraint
Designing mappings with multiple targets, Mapping Logical and Physical diagram overview
What is a Staging Area and Work schema
Overview of Integration Process
Integration Types - Control Append, Incremental Update, SCD
About Execution Location, Knowledge Modules (KM) overview, Types of knowledge modules
Using knowledge modules with ODI Mappings
Designing Mappings
Designing a Mapping with multiple Source Data stores, Creating Joins and Filtering Data
Disabling Transformations, Overview of the Flow
Specifying the Staging Area. Selecting Knowledge Modules
Mapping execution Monitoring and Debugging
Monitoring Mappings, Creating Objects with Operator, Viewing Sessions , Tasks & troubleshoot
Execution with simulation, working with Errors and tips for Preventing Errors
Designing Mappings: Advanced Topics
Mapping with Business Rules and Working with re-usable mappings, multiple files
Creating and Tracking Variables. Showing Variable Values in Log
Creating User Functions, Mapping Substitution Methods
Working with Standard, Native and Specific sequences. Resetting sequences
Working with KM (Knowledge Modules)
Working with LKM for Oracle, ANSI SQL, Files, XML
Working with IKM for Oracle, ANSI SQL, Files, XML
Working with data validation through CKM
Customizing Reverse Engineering Using RKM
Implementing CDC in ODI through JKM
Creating and Running ODI procedures
What is a Procedure and examples of Procedures. Creating Procedures
Adding Commands, Options, Running a Procedure and View Results with Operator
Creating and Running ODI Packages
What is a Package and how to create and execute a Package
Creating Advanced Packages, Error Handling, Controlling an Execution Path
Creating a Loop, Using the Advanced tab
Managing 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 and Handling concurrent changes
Enforcing Data Quality and Auditing Data with ODI
Working with Changed Data Capture
Administering ODI Resources: Advanced Topics
http://www.futurepointtech.com/odi-training.html
|
|
