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
Implementing Lookups
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
Tracking Variables
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
CDC Consistency
Using CDC
Viewing Data/Changed data
Using Journalizing
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...
05/07/2018: This Client asked JBI to run an intensive ReactJS course for Developers who were already familiar with Javascript, CSS and some of whom may have...
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...
31/01/2019: Java is a well-established programming language that has been around since the mid 1990s. It’s used extensively in industry and commerce, and...
11/01/2019: Cloud computing has entered its second decade and is still growing strongly. Gartner, for example, has forecast the global public cloud services...
PRIVATE COURSES
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
You can customise this course to
suit your exact needs here
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"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe