
Compare specific and standard sequences in mapping and in procedure, and observe how the agent processes data, causing different sequence increments for each row.
Lock components such as mappings and procedures to prevent edits, create and compare multiple versions of mappings, and restore a prior version to manage secure, auditable changes in ODI.
Learn to configure the reedman utility to read mail, specify mail server credentials and attachments, then use the wait-for-table step to ensure target table creation and data loading in ODI.
Explore star schema, snowflake schema, and galaxy schema in data warehousing, comparing their fact and dimension tables and normalization levels.
Configure a standalone agent by creating a master and work repository, selecting templates (standalone, Oracle agent, agent libraries, console, and Oracle Enterprise Manager), and starting the agent via command prompt.
What is Oracle Data Integrator (ODI) 12C?
Oracle Data Integrator 12C (ODI) is an extract,load and transform (ELT) (in contrast with the ETL common approach) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.
What are we learning in the course?
ODI 12C Architecture and Installation Steps
ODI 12C Repositories
ODI 12C Components
Knowledge Modules with Examples
Procedures,Variables,Reusable Mapping,Scenarios and Sequence
ODI 12C Packages
SCD Implementation in ODI
ODI Agent and Load Plan
ODI Security,Profile and User Creation
Career Perspective:
If you want to pursue a career as an ETL developer,you should definitely consider taking this course.Most importantly,If you learn one ETL tool whether it's ODI 12C or Informatica,learning other ETL tools won't be difficult.Also,the demand of ETL developer is keep on increasing as the data size is increasing.
After this Course:
Once you are done with the course,you will have maximum knowledge of ODI 12C concepts that you can implement in the industry.
Cheers..!!
Have a Great Learning..!!!