Would you like to be a ODI/ETL Developer with ODI 12C Training? ODI 12C is a last version of Oracle's integrator tool. In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of the theorical informations to provide a better education.
After obtaining these informations, you’ll learn ODI objects/new components and design new packages/mappings. . In this training, all of the abilities that a ETL and ODI developers must have will be explained. You’ll be able to have a wide range of informations over the topics listed bellow:
ODI (Oracle Data Integrator) 12C
Why you should have this course?
This is not a theorical education. All of lessons are implemented in my machine. You can find all steps that you need to know when you want to develop a project in ODI 12C. I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the real projects.
With various documents and end-of-chapter quizes, I aim to reinforce the topics.
As being more than 6 years in the sector and being an instructor in companies that have big DWH structures, I provide this course.
You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.
We'll download Oracle that we need.
We'll install Oracle step by step.
You can find all step in here ODI and Database.
Installation master and work repository in ODI 12C.
We'll create and design Physical and Logical Schema. Everything that you will need about topology in this section.
We can say Interface from ODI 11g, we will see its name as Mapping.
Importing tables that we will use them into Mapping and Package.
We can start developing sample projects.
Importing some important knowledge modules and you can meet knowledge module.
Using Joing between more then one tables and some filters.
Hardcode data that is mean what we want to see in our target table, we need to enter manually.
Performing sequence in a target table.
We have created a few mapping and we can use them into a package.
Using a variable in a package. Variable has a value that can be string , number or date. in this section you will learn using string and number.
A date variable can be used lots of projects.
Lookup tables has some values, they are usually description of a value.
The components are new features in ODI 12C. And we will see using Join Component in this section.
Union combines more than one results. But we shouldn't forget all scripts have same column number and character types.
Sorting Data over a number column using Sort component. it is new feature in ODI 12C.
Distinct component is used for checking dublicate rows. it is a new feature in ODI 12C.
When we want to use "not in" or "in" or equal with other column that is in other table we can use subquery component. it is a new feature in ODI 12C.
continuing with subquery component
Expression component can be used for heaping some results. We will see it.
Aggregate component is a new feature in ODI. we can use it for using "SUM", "COUNT" or any math formulas.
For seperating datas over some cases we need to use split component. This is new feature in ODI.
We will see how to use a reuseble mapping. And understand why it is used.
After graduation from university I started to work as a DWH-ETL Developer in the telecommunication company. I am a data warehousing and ETL specialist having over 5+ years of experience in telecommunication and banking Industry.
Now, I am here to share my Know-how, experience and advantages of working Data Warehouse and ETL projects with them who want to plan students' career in DWH-BI and for them who want to learn about these technologies and discover further.