KPI Partners Blog

Executing An ODI Load Plan

Posted by KPI Partners News Team on Mon, Jun 17, 2013 @ 12:41 PM

by Varun Reddy

Oracle Data Integrator (ODI): Executing A Load Plan

Load Plan 

A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Procedures, interfaces, packages, variables, and can be added to Load Plans for executions in the form of scenarios in a Load Plan.

Read More

Tags: Data Warehousing, Varun Reddy, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Why ODI? A Look Into Oracle Data Integrator Architecture

Posted by KPI Partners News Team on Mon, Jun 03, 2013 @ 07:29 AM

by Varun Reddy

E-L-T vs. E-T-L

Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture.  The declarative design approach separates the declarative rules from the implementation details. ODI architecture eliminates the need for a standalone ETL (Extract-Transform-Load) server and proprietary engine while leveraging the inherent power of RDBMS engines.

Read More

Tags: Data Warehousing, Training, Varun Reddy, Oracle, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog