UrbanPro
true

Oracle odi 12c training

LIVE
25 Hours

Course offered by Sri Ram

0 review

ORACLE DATA INTEGRATOR

 

Introduction

  1. What is Oracle Data Integrator?
  2. Why Oracle Data Integrator?
  3. Overview of ODI 12c Architecture
  4. Overview of ODI 12c Components
  5. About Graphical Modules
  6. Types of ODI Agents
  7. Overview of Oracle Data Integrator Repositories

Administering ODI Repositories and Agents

  1. Administrating the ODI Repositories
  2. Creating Repository Storage Spaces
  3. Creating and Connecting to the Master Repository
  4. Creating and Connecting to the Work Repository
  5. Managing ODI Agents
  6. Creating a Physical Agent
  7. Example of Load Balancing

ODI Topology Concepts

  1. Overview of ODI Topology
  2. About Data Servers and Physical Schemas
  3. Defining the Physical Architecture
  4. Defining the Logical Architecture
  5. Mapping Logical and Physical Resources
  6. Defining Agents
  7. Defining a Topology
  8. Planning the Topology

Describing the Physical and Logical Architecture

  1. Overview of Topology Manager
  2. Creating a Data Server
  3. Testing a Data Server Connection
  4. Creating a Physical Schema
  5. Creating Logical Architecture
  6. Overview of Logical Architecture and Context Views
  7. Linking the Logical and Physical Schemas

Setting Up a New ODI Project

  1. Overview of ODI Projects
  2. Creating a New Project
  3. Using Folders
  4. Organizing Projects and Folders
  5. Understanding Knowledge Modules
  6. Using Markers

Oracle Data Integrator Model Concepts

  1. What is a Model?
  2. Understanding Metadata in ODI
  3. Understanding Reverse Engineering
  4. Creating Models
  5. Organizing Models
  6. Creating Datastores
  7. Using Constraints in ODI
  8. Creating Keys and References

Organizing ODI Mapping

  1. How mapping works on odi
  2. Business Rules for Interfaces
  3. Reusable mapping

Knowledge Modules

  1. What is Knowledge Module
  2. What are different type of KM
  3. How to use native KM
  4. Customization of KM

Components in ODI

  1. Filter
  2. Exprerrssion
  3. Sorter
  4. Distincr
  5. Split
  6. Aggregrator
  7. Pivot
  8. Unpivot
  9. Lookup
  10. Join

Interfaces: Monitoring and Debugging

  1. Monitoring Interfaces
  2. Using Operator
  3. Viewing Sessions and Tasks
  4. How to Monitor Execution of an Interface
  5. How to Troubleshoot a Session
  6. Keys to Reviewing the Generated Code
  7. Working with Errors
  8. Tips for Preventing Errors

 

Using ODI Packages

  1. What is a package?
  2. Creating a package
  3. Executing a package
  4. Creating Advanced Packages
  5. Error handling
  6. Controlling an Execution Path
  7. Creating a Loop
  8. Using the Advanced tab

ODI Tool Box

  1. OdiFileAppend
  2. OdiFileCopy
  3. OdiFileDelete
  4. OdiFileMove
  5. OdiFileWait
  6. OdiMkDir
  7. OdiOutFile
  8. OdiSqlUnload
  9. OdiUnZip

 

Managing ODI Scenarios and Versions

  1. What is a Scenario?
  2. Managing Scenarios
  3. Preparing Scenarios for Deployment
  4. Automating Scenario Management
  5. Scheduling the ODI Scenario
  6. Overview of ODI version management
  7. Scheduling the scenarios

IMPLEMENTING SLOWLY CHANGING DIMENSIONS

Working with Changed Data Capture

  1. Overview of ODI version management
  2. Techniques of Changed Data Capture
  3. Changed Data Capture in ODI
  4. CDC Consistency
  5. Using CDC
  6. Viewing Data/Changed data
  7. Using Journalizing
  8. OdiWaitForData
  9. OdiWaitForLogData
  10. OdiWaitForTable

Working with Flat-Files

  1. What is flat-file?
  2. Types of flat files
  3. Reverse engineering the metadata from flat files
  4. Error handling while importing flat files

 

Load Plans in ODI

  1. Types of load plans
  2. Implementing loadplans
  3. Calling packages inside load plan
  4. Exception handling loadplan using package

 

General concepts :-

 

  1. Import and export
  2. Soft import and soft export
  3. Materializing shortcuts
  4. Generate DDL using odi studio
  5. Exporting odi master and work repository
  6. Command line programmes, Starting odi scenarios from command line etc...

About the Trainer

Avg Rating

0 Reviews

1 Students

3 Courses

Sri Ram

B.tech

I have 8+ years of experience in data warehousing, currently working as Oracle ODI consultant trained more than 320+ students with many of the consultancies I am conducting sessions since 2 years with many of students.

I will give you best training industry with each and every component and scenario.

I can help you installing and configuring the odi on your local pc with agent.

Students also enrolled in these courses

LIVE
14 reviews
1 Hours
10,000 Group Class (max 5)
20,000 1-on-1 Class

Course offered by Anupam Thakur

23 reviews
LIVE
27 reviews

Course offered by Surya Narayana Reddy

14 reviews
LIVE

Course offered by Oracle Primavera Trainer Profile

25 reviews
LIVE
6 reviews

Course offered by Mahesh

1 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Oracle odi 12c training by Sri Ram

Sriram picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Oracle odi 12c training by Sri Ram

Sriram picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more