
How to go forward for this course
Why lots of installation steps
How to understand the points
to share my ODI experience with you
What is the meaning of data warehouse and data lake
why they are using
What kind of environment they can serve to us
What is the picture of data flow
what does the meaning of ETL/ELT
What do we need to install
How is ODI working with them
Why we need to use ODI or other Tools to get data
How is ETL lifecycle
Data flow for ACID as set of properties of database transaction
What is the meaning of quickstart installation
Why we will go forward 2 different type installation method
Which webpage we can download ODI quickstart environment
how to install virtualbox
Open Quickstart Demo ova file into VirtualBOX
Open ODI studio
Connect to existing repository
After prepared the environment which should have Oracle DB, SQL Developer, ODI Studio and its connections, so we can test them now if they are running properly or not.
How to reach to Database Tables
Open topology and test the connections
Description of Section
Who should perform same steps
What will be the requirements in your real projects and relation with this section
Creating a virtual machine and installing Centos to it.
Configuration and Checking the prerequisites before oracle
Reaching to Virtual Machine from Host machine
Uploading the installation file into virtual machine
Starting the installation
Checking DB situation
Starting Database
How to reach over Putty to new Database with command line
Java installation on centos
How to install ODI from centos Command
How to connect to Database from ODI
How to create a new Repository User for ODI
SUPERVISOR USER and Privileges
You can find all step in here ODI and Database.
What is Physical Schema
What is Logical Schema
Why we need to use Context
How to get all tables from Database User into ODI
Importing tables that we will use them into Mapping and Package.
We can say Interface from ODI 11g, we will see its name as Mapping.
What is the logic of Projects and Mappings
How is their relation between each other
How to load data into a new target table
How to show new table to ODI 12C
Which type of file we should save for reading later
What is csv file
Over Winscp How to upload the correct area which we will use later that path on ODI to show file to it.
Why we have to use Physical Schema
How to define Data server for Source files
how to create logical schema and connect to a Physical schema
How to change file to an object in ODI
How to create a new datastore for File and show column names as attributes
How to prepare a target table for a source file with the fastest way
Defining columns and types
Create a new Mapping
move your datastores into mapping area
Run the mapping
see the results
How to import Knowledge Module
The types of Knowledge Modules
Summary for all steps in order to see basically
For Which Scenarios Extracting directly from files
Importing some important knowledge modules and you can meet knowledge module.
Hardcode data that is mean what we want to see in our target table, we need to enter manually.
We have created a few mapping and we can use them into a package.
We can start developing sample projects.
Scenario that is like a snapshot of mapping or 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.
how to prepare to run Cassandra Properly
How to install Cassandra on Centos
How to write query for cassandra after connection
Create a new keyspace and a new table
inserting data into new table
How to create a Data Server for connecting to cassandra
Creating a model in order to see tables they belongs to cassandra
View cassandra table data over ODI
How to get data from Cassandra to Oracle/Relational
How to prepare a map for extracting data from cassandra to a file
Would you like to be an 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.