Oracle Data Integrator
Course Content
1. Introduction to Oracle Data Integrator
• What is Oracle Data Integrator?
• Why Oracle Data Integrator?
• Overview of ODI 11g Architecture
• Overview of ODI 11g Components
• About Graphical Modules
• Types of ODI Agents
• Overview of Oracle Data Integrator Repositories
2. Administrating ODI Repositories and Agents
• Administrating the ODI Repositories
• Creating Repository Storage Spaces
• Creating and Connecting to the Master Repository
• Creating and Connecting to the Work Repository
• Managing ODI Agents
• Creating a Physical Agent
• Launching a Listener, Scheduler and Web Agent
• Example of Load Balancing
3. ODI Topology Concepts
• Overview of ODI Topology
• About Data Servers and Physical Schemas
• Defining the Physical Architecture
• Defining the Logical Architecture
• Mapping Logical and Physical Resources
• Defining Agents
• Defining a Topology
• Planning the Topology
4. Describing the Physical and Logical Architecture
• 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
5. Setting up a New ODI Project
• Overview of ODI Projects
• Creating a New Project
• Using Folders
• Organizing Projects and Folders
• Understanding Knowledge ModulesExchanging ODI Objects
• Exporting and Importing Objects
• Using Markers
6. ODI Model Concepts
• What is a Model?
• Understanding Metadata in ODI
• Understanding Reverse Engineering
• Creating Models
• Organizing Models
• Creating Data stores
• Using Constraints in ODI
• Creating Keys and References
7. Organizing ODI Models and Creating Data Sources
• What is an Interface?
• Business Rules for Interfaces
• What is a Mapping?
• What is a Join?
• What is a Filter?
• What is a Constraint?
• What is a Staging Area?
• Creating a Basic Interface
8. ODI Interface Concepts
• What is an Interface?
• Business Rules for Interfaces
• What is a Mapping, Filter, Join?
• Overview of Integration Process
• What is a Staging Area?
• About Execution Location
• Using Knowledge Modules (KM) with ODI Interface
• Creating a Basic Interface
9. Designing Interfaces
• Designing an Interface
• Multiple Source Data stores
• Creating Joins
• Filtering data
• Disabling Transformations
• Overview of the Flow
• Specifying the Staging Area
• Selecting Knowledge Modules
10. Interfaces : Monitoring and Debugging
• Monitoring Interfaces
• Using Operator
• Viewing Sessions and TasksHow to Monitor Execution of an Interface
• How to Troubleshoot a Session
• Keys to Reviewing the Generated Code
• Working with Errors
• Tips for Preventing Errors
11. Using ODI Procedures
• What is a Procedure?
• Examples of Procedures
• Creating Procedures
• Adding Commands
• Adding Options
• Running a Procedure
• Using Operator to View Results
12. Using ODI Packages
• What is a package?
• Creating a package
• Executing a package
• Creating Advanced Packages
• Error handling
• Controlling an Execution Path
• Creating a Loop
• Using the Advanced tab
13. Managing ODI Scenarios and Versions
• What is a Scenario?
• Managing Scenarios
• Preparing Scenarios for Deployment
• Automating Scenario Management
• Scheduling the ODI Scenario
• Overview of ODI version management
• Using Version Browser and Version Comparison Tool
• Handling concurrent changes

Benefits:
1. Complete Material
2. Lab Practice Set on Every Topic we cover
3. Complete Hands on training.

Courses Offerings

• Android
• AIX Administration
• Business Analyst
• Citrix XenApp
• Cognos 10 BI & Tm1
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• Informatica
• I Phone
• Java/J2EE
• J Query
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS – HRMS
• Oracle APPS – SCM
• Oracle APPS – Financial
• Oracle APPS – Technical
• Oracle BI Apps
• Oracle BI Publisher
• Oracle DBA 11g
• Oracle RAC
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• PHP
• Perl Scripting
• SAP SD , BO , FICO , BI / BW , APO
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager
• Unix Administration
• VMWare
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webmethods
• Webservices , SOAP ( JAVA)



Visit www.futurepointtech.com for course curriculum

Drop a mail info@futurepointtech.com we will get in touch with u