This Oracle ODI training course is for ETL Developers who wish to extend their understanding of ODI. This course will cover the product architecture and practical use of the Tool, so you can hit the ground running when you start using the product after the course. The course can be tailored to cover different Database Technologies: Oracle, MySQL and SQLServer, as well as Flat Files and XML sources and targets.
Overview of Different Types of KMs
Guidelines for KM Developers
Working with Substitution Methods
Applying Various ODI Tags
Implementing Java in KMs
Troubleshooting and Debugging KMs
Designing Integration Interfaces: E-LT and ETL - Style Interfaces
Selecting LKM and Mono-Connection (Single Technology) IKM
Applying Best Practices for Integration Interfaces Design
Designing Temporary Interfaces
Combining Multiple Datasets
Using Set-Based Operators
Partitioning ODI Datastores
Describing a Variable's Scope
Inserting Variables in Object Properties
Using Variables within Variables
Defining Variables in the Resource Name of a Datastore
Applying Variables in Topology Objects
Setting Variables as Start Up Parameters
Interacting Programmatically with ODI
Overview of ODI SDK
Introduction to Groovy
Using Groovy Editor
Automating Development Tasks with Groovy
What are Complex Files
Determining Technical Requirements for Complex Files Project
Applying nXSD Schema: an Example
Setting up the Topology for Complex Files
Creating and Reverse-Engineering a Complex Files Model
Designing an Interface with Complex Files
Overview of ODI version management
Techniques of Changed Data Capture
Changed Data Capture in ODI
CDC Strategies and Infrastructure
Viewing Data/Changed data
Loading and Integration Patterns
Selecting Staging Area Location
Working with Slowly Changing Dimensions (SCD)
Working with Changed Data Capture
Using ODI with Oracle GoldenGate
Describe Big Data concepts
Contrast Hadoop, NoSQL, Apache, Hive, HBase, HDFS
Implement ODI mapping for Big Data to Oracle SQL
See why people choose JBI
31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum...
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
06/08/2018: Kotlin develops quickly! Last year brought us many changes and possibilities. Both in the community and in the language. Let’s summarize them....
31/07/2018: Happy 3rd birthday PowerBI!!! A note from a user/trainer... PowerBi, after 3 years from its initial release, is a mature and rich tool for data...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"