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 dataODI ArchitectureODI ComponentsGraphical ModulesODI AgentsOracle Data Integrator Repositories overviewAdministering ODI Repositories and AgentsAdministrating the ODI RepositoriesCreating Repository Storage SpacesCreating and Connecting to the Master RepositoryCreating and Connecting to the Work RepositoryCreating a Wallet to Securely Store CredentialsManaging ODI AgentsCreating a Physical AgentODI Topology ConceptsOverview of ODI TopologyAbout Data Servers and Physical SchemasDefining the Physical ArchitectureDefining the Logical ArchitectureMapping Logical and Physical ResourcesSetting Up a New ODI ProjectCreating a New ProjectCreating and Maintaining FoldersOrganizing Projects and FoldersExchanging ODI Objects and Sharing Global ObjectsObject export and importCreating and Labeling with MarkersOracle Data Integrator Model ConceptsModel overviewUnderstanding Metadata in ODIUnderstanding Reverse EngineeringCreating ModelsOrganizing ModelsCreating Data storesConfiguring Constraints in ODICreating Keys and ReferencesOrganizing ODI Models and Creating Data StoresWhat is a Mapping?Business Rules for MappingsCreating a BasicMapping 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 ProcessWhat is a Staging Area?Execution LocationCreating an Intermediate MappingDesigning MappingsDesigning a MappingMultiple SourceData storesCreating JoinsFiltering DataDisabling TransformationsOverview of the FlowSpecifying the Staging AreaMapping: Monitoring and DebuggingMonitoring MappingsObjects with OperatorSessions and TasksMonitoring Execution of a MappingTroubleshootingKeys to Reviewing the Generated CodeErrorsCreating and Running ODI ProceduresCreating ProceduresAdding CommandsAdding OptionsRunning a ProcedureViewing Results with OperatorUsing ODI PackagesCreating a PackageExecuting a PackageCreating Advanced PackagesError HandlingControlling an Execution PathCreating a LoopUsing the Advanced tabODI Scenarios and VersionsManaging Scenarios with Load PlansPreparing Scenarios for DeploymentAutomating Scenario ManagementScheduling the ODI ScenarioOverview of ODI version managementHandling concurrent changes
Terms and Conditions
© 2020 iTrain. All rights reserved.