Oracle Data Integrator 11g Certified Implementation Essentials Syllabus

Introduction to Oracle Data Integrator (ODI)

1. Describe the benefits of ODI (including ODI architecture - Extract Load Transform) and it's typical use cases 
2. Describe the ODI components and their uses 
3. Architecture Overview 
4. Describe ODI Architecture 
5. Install and Configure the physical and logical architecture 
6. Explain the Fusion Middleware Components - Upgrade Assistant, Repository Creation Utility and Java Enterprise Edition (JEE) Components and High Availability 

ODI Models and Datastores

1. Create ODI datastores 
2. Create and organize ODI Models 
3. Reverse engineer the metadata 
4. Explain ODI constraints 
5. Configure auditing 
6. Install and configure Data validation 

Project Development

1. Create a project within ODI 
2. Explain ODI interface 
3. Describe the concepts of mapping, join, and filter and the process of implementing business rules as well as the concepts of staging area and execution location 
4. Create and execute a basic ODI Interface 
5. Create lookups 
6. Design ODI interfaces with multiple-source datastores 
7. Create joins and lookups, and filter data 
8. Configure the flow in the ODI Interface, specify the ODI Interface, staging area and execution location 
9. Modify and develop knowledge modules 
10. Describe what happens at run time 
11. Monitor the execution of interfaces 
12. Troubleshoot run-time errors in interfaces, prevent errors by following the best practices when designing interfaces 
13. Configure the use of business rules, variables and set-based operators and use data sets and sequences 
14. Use partitioning, temporary indexes, and temporary interfaces 
15. Use user functions and substitution methods 

Managing Execution

1. Use ODI packages to create a complete workflow 
2. Use variables in packages (refresh, startup parameters). 
3. Create package steps of different types 
4. Execute and monitor a package 
5. Define complex workflows in ODI packages involving branches and loops 
6. Generate and regenerate an ODI scenario 
7. Use the load plan editor to define a load plan 
8. Design a sequence of hierarchical steps for the load plan 
9. Create Packages and Load Plans 
10. Manage exceptions with Load Plans 
11. Configure Load Plans to restart child sessions 

Integrating OGG with ODI

1. Describe the purpose of Changed Data Capture (CDC) with ODI and the types of CDC implementations possible with ODI 
2. Deploy Goldengate CDC with ODI 
3. Perform journalizing 
4. Interpret and troubleshoot the results of CDC 

Doing more with ODI

1. Describe the ODI Software Development Kit (SDK) 
2. Describe ODI Web-Based Components 
3. Explain the role of ODI in Big Data 
4. Describe the role of ODI in BI integration 

Enterprise Data Quality (EDQ) Profiling

1. Describe the ways where ODI and EDQ can share architecture components (infrastructure, sources and targets, etc) 
2. Configure EDQ to work with Data Stores, Snapshots, Staged Data, Exports 
3. Explain basic statistics from data 
4. Describe the tracking of changing data from same data stores (trends) 
5. Describe profiling results and the use of Result books and Publish features 

EDQ Batch Processing

1. Explain the parsing process and referencing review results 
2. Perform a matching process, identify duplicated records, balance performance and duplicate detection accuracy 
3. Explain address verification and Address Verification statistics 
4. Create the main job that includes all processes that were created and invoke it from ODI