Among the major ETL tools in the market , Oracle Data Integrator outshines not just for a couple of reason. Oracle has invested a lot in developing the tool after it took over from Sunopsis. The tool is placed as a part of the Oracle Fusion Middleware stack. If you are a customer who is using Oracle Warehouse Builder , then ODI is a similar tool but it is engineered for the next generation ETL with many features.
All the transformations happens on the target database as SQL ,so it is not a black box and it allows developers/administrators to look into what is going on and helps in quick debugging. ETL happening via ODI uses the resource of the target database server.
I would like to recommend a Hands-On Tutorial Book that has been published by PACKT which covers the below topics in detail.
All the transformations happens on the target database as SQL ,so it is not a black box and it allows developers/administrators to look into what is going on and helps in quick debugging. ETL happening via ODI uses the resource of the target database server.
I would like to recommend a Hands-On Tutorial Book that has been published by PACKT which covers the below topics in detail.
- Installation, Deployment, and Configuration
- Defining the Oracle Data Integrator Security
- Advanced Topology
- Using Variables
- Knowledge Module Internals
- Inside Knowledge Modules
- Advanced Coding Techniques
- Package Loop and File Processing
- XML and Web Services
- Advanced Coding Techniques Using the SDK
This book is a quick starter for any body who wants to take a deep dive into ETL.
