Oracle Data Integrator 12c: Advanced Workshop
In this workshop, you will learn how to use every single component in the Mappins in order to transform and process your data effectively. All the components will be used in the mappings. Additionally, you will learn how to modify the existing knowledge modules. You will create a new knowledge module from the beginning, too. Slowly Changing Dimension Type 2 will be also covered. This advanced workshop is designed to improve the developers’ skills.
About the instructor Cuneyt Yilmaz
Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB.
Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed!
Audience:
Administrator, Analyst, Architect, Database Administrator, Implementer
Prerequisites:
Delegates attending this advanced workshop should have skills and knowledge equal to this training:
Course content
Agenda:
- Lesson 1: Introduction
- Lesson 2: ODI Knowledge Modules: Overview
- Lesson 3: Designing Mappings: Advanced Topics 1 (Components Palette)
- a- Dataset
- b- Distinct
- c- Filter and Sort
- d- Set
- e- Aggregate
- f- Join
- g- Lookup
- h- Split
- Lesson 4: Designing Mappings: Advanced Topics 2 (Components Palette)
- a- Expression
- b- Table Function
- c- Subquery Filter
- d- Pivot and Unpivot
- e- Flatten and Jagged
- Lesson 5: Developing Knowledge Modules
- Lesson 6: Designing ODI Integration Mappings
- Lesson 7: Designing Advanced Integration Mappings (Slowly Changing Dimensions)
- Lesson 8: Using Variables in ODI in ODI objects (Looping Data Stores automatically)
- Lesson 9: Accelerating Development with Groovy
- Lesson 10: Working with ASCII Files (JSON, XML and Complex Files)
- Lesson 11: Implementing Change Data Capture using JKM
- Lesson 12: Enhancing ODI Security (LDAP Integration using Oracle Unified Directory)
- Lesson 13: Enabling and Disabling Wallet Password
- Lesson 14: Advanced ODI Administration and Configuring ODI Console for Data Lineage
