Course code: O1223
Oracle 12c ODI Data Integrator course; hands on training exploring ODI architecture, administration and key functionality and integration.
Data Warehouse Administrator
Data Warehouse Analyst
BI KnowledgeData Warehouse DesignKnowledge of ETL
iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835
Oracle 12c Data Integrator, built on high performance ELT, platform flexibility and intuitive user experience is a key component and latest version of Oracle's complete OBI offering and enterprise data integration platform. Designed around continuous hands on labs iTrain's course provides attendees with essential skills and hands on experience to fully harness it's enterprise potential.
The course will explore the product from architectural, implementation and best use perspectives, provding attendees with understanding how ODI maximises next generation Extract-Load-Transformation technology to provde crucial analytics and true business intelligence - converting data into a business asset; information.
Attendees will start with basic blocking and interfaces creation through to more complex, advanced aspects of ODI including data workflows, management and monitoring, scheduling and impact analysis learning how to implement, administer and manage high volume movement and transformation of data between disparate platforms
As with all iTrain courses ODI can be delivered as a closed course on your site or a third party location. As company specific training iTrain will work with you to tailor content to your organisation and project's specific requirement and objectives. To assist with this iTrain provide a full mobile classroom the Classroom in a Box.
Oracle Data IntegratorInformation, not data.ODI ArchitectureODI Components Graphical Modules ODI AgentsOracle Data Integrator Repositories overviewAdministering ODI Repositories and AgentsAdministrating the ODI Repositories Creating Repository Storage SpacesCreating and Connecting to the Master Repository Creating and Connecting to the Work Repository Creating a Wallet to Securely Store Credentials Managing ODI AgentsCreating a Physical AgentLaunching a Listener, Scheduler and Web AgentODI Topology ConceptsOverview of ODI TopologyAbout Data Servers and Physical Schemas Defining the Physical ArchitectureDefining the Logical Architecture Mapping Logical and Physical Resources Defining AgentsDefining a Topology Planning the TopologyDescribing the Physical and Logical ArchitectureTopology Navigator Creating Physical Architecture Creating a Data ServerTesting a Data Server Connection Creating a Physical Schema Creating Logical ArchitectureOverview of Logical Architecture and Context Views Linking the Logical and Physical ArchitectureSetting Up a New ODI Project Creating a New ProjectCreating and Maintaining Folders Organizing Projects and Folders Understanding Knowledge ModulesExchanging ODI Objects and Sharing Global Objects Object export and importCreating and Labeling with MarkersOracle Data Integrator Model ConceptsModel overviewUnderstanding Metadata in ODIUnderstanding Reverse Engineering Creating ModelsOrganizing Models Creating Data storesConfiguring Constraints in ODI Creating Keys and ReferencesOrganizing ODI Models and Creating Data storesWhat is a Mapping? Business Rules for Mappings Creating a Basic Mapping What is a Join?What is a Filter? What is a Constraint?What is a Staging Area?ODI Mapping ConceptsWhat is a Mapping? Business Rules for MappingWhat is a Mapping, a Filter, a Join? Overview of Integration Process What is a Staging Area?Execution LocationMapping with Knowledge Modules (KM) Creating an Intermediate MappingDesigning Mappings Designing a Mapping Multiple Source Data stores Creating JoinsFiltering DataDisabling Transformations Overview of the Flow Specifying the Staging Area Selecting Knowledge ModulesMapping: Monitoring and DebuggingMonitoring MappingsObjects with Operator Sessions and TasksMonitoring Execution of a Mapping TroubleshootingKeys to Reviewing the Generated Code ErrorsDesigning Mappings: Advanced Topics 1Mapping with Business Rules Overview of Business Rule Elements Creating and Tracking VariablesCreating User Functions Mapping Substitution Methods Modifying a KMShowing Variable Values in LogCustomizing Reverse Engineering Using RKMDesigning Mappings: Advanced Topics 2Using Partitioning in a Mapping Reusable MappingsDerived Select (Subselect) for Reusable Mappings Using User FunctionsCreating a User Function Using Substitution MethodsDeveloping Your Own Knowledge ModuleCreating and Running ODI proceduresCreating Procedures Adding Commands Adding OptionsRunning a ProcedureViewing Results with OperatorUsing ODI Packages Creating a Package Executing a PackageCreating Advanced Packages Error HandlingControlling an Execution Path Creating a LoopUsing the Advanced tabStep-by-Step DebuggerStarting a Session in Debug mode Specifying Debug Properties Control Execution FlowScreen Step NumberingODI Scenarios and VersionsManaging Scenarios with Load Plans Preparing Scenarios for Deployment Automating Scenario Management Scheduling the ODI ScenarioOverview of ODI version managementHandling concurrent changesUsing Load Plans What Are Load Plans?Load Plan Editor
Terms and Conditions
© 2017 iTrain. All rights reserved.