EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
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
03/10/2017: Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...
05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...
05/10/2017: Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...
11/10/2017: The training was to target a team of developers, with a mix of Java, C# and some C++. The team made heavy use of Java SE with some elements of...
05/10/2017: The BBC, who have a very substantial investment in technology, were keen to improve the quality of software development: to instil developers...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
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"