Oracle data integration

Oracle data integration

• 1.
  Oracle Data IntegratorCurriculum Administration and Development Course Objectives Duration: 25 Hours  Describe architecture of Oracle Data Integrator 10g   Apply ODI Topology concepts for data integration    Describe ODI Model concepts   Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations   Explore, audit data, and enforce data quality with ODI   Administer ODI resources and setup security with ODI   Implement Changed Data Capture with ODI   Use ODI Web services and perform integration of ODI with SOA  Course Topics 1) Introduction 1 Sessions  Identifying the Course Units    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) Administering ODI Repositories and Agents 1 Sessions  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 1 Sessions  Overview of ODI Topology   About Data Servers and Physical Schemas  Contact US: http://www.bispsolutions.com Page 1
• 2.
   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 1 Sessions  Overview of Topology Manager   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 1 Sessions  Overview of ODI Projects   Creating a New Project    Using Folders   Organizing Projects and Folders   Understanding Knowledge Modules   Exchanging ODI Objects    Exporting and Importing Objects   Using Markers  6) Oracle Data Integrator Model Concepts 1 Sessions   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 stores 1 Sessions  What is an Interface?   Business Rules for Interfaces    What is a Mapping?   What is a Join?   What is a Filter?  Contact US: http://www.bispsolutions.com Page 2
• 3.
   What isa Constraint?   What is a Staging Area?   Creating a Basic Interface  8) ODI Interface Concepts 1 Sessions  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 1 Sessions   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 1 Sessions  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   Working with Errors   Tips for Preventing Errors  11) Designing Interfaces: Advanced Topics 1 Sessions  Using Business Rules in Interfaces   Overview of Business Rule Elements    Using variables   Using User Functions   Using Substitution Methods   Modifying a KM    Developing Your Own KM   Using RKM for Customized Reverse Engineering  Contact US: http://www.bispsolutions.com Page 3
• 4.
  12) Using ODI procedures 1 Sessions   What is a Procedure?   Examples of Procedures   Creating Procedures   Adding Commands    Adding Options   Running a Procedure   Using Operator to View Results  13) Using ODI Packages 1 Sessions   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  14) Managing ODI Scenarios and Versions 1 Sessions  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  15) Enforcing Data Quality and Auditing Data with ODI 1 Sessions  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  16) Working with Changed Data Capture 1 Sessions  Overview of ODI version management    Techniques of Changed Data Capture   Changed Data Capture in ODI  Contact US: http://www.bispsolutions.com Page 4
• 5.
   CDC Strategies and Infrastructure   CDC Consistency    Using CDC   Viewing Data/Changed data   Using Journalizing  17) Administering ODI Resources: Advanced Topics 1 Sessions   Using Open Tools   Installing Open Tools   Using Open Tools in a Package   Using Open Tools in a Procedure or in a KM    Developing Your Own Open Tools   Setting Up ODI Security   Defining Security Policies   Defining Password Policies  18) Case Study 1 1 Sessions  Aggregate Example   19) Case Study 2 1 Sessions  Expression Trans & Filter Transformation 20) Case Study 3 1 Sessions  Joiner Transformation & Lookup Transformation 21) Case Study 4 1 Sessions  Rank Transformation & dNormalizer Transformation 22) Case Study 5 1 Sessions  Router Transformation & Seq Generator Trans Contact US: http://bispsolutions.wordpress.com Page 5