ODI - (Interface|Mapping)

Card Puncher Data Processing

About

An interface in Designer consists of a set of rules that define the loading of a datastore or a temporary target structure from one or more source datastores.

Steps

New Mapping

You would only need the Empty Dataset if you are making more than one source or target.

Run

Deployment Specification

Odi Deployment Specification Ds

Components of an Interface

The interfaces use the following components:

  • Datastores defined in the models as sources and target of the loading process.
  • Knowledge Modules to generate the appropriate processes.
  • Variables and Sequence to store values or counters in the expressions.
  • Users functions to ease the transformation rule coding.

Flow and knowledge modules

Odi Designer Interface Flow

The flow is the set of loading and integration strategies for mapped data, based on knowledge modules as :

Documentation / Reference





Discover More
Endeca Flexfield Security
Endeca

Stop the agent process Copy the jar files located in the lib directory of the downloaded files Paste them in the following location. If the ODI agent is a Java application running in WebLogic Server: C:\Oracle\Middleware\user_projects\domains\odiagent\lib....
Odi Designer Interface Ikm
ODI - (Load|Integration) Knowledge Module (IKM)

They are used to integrate (load) data into the target. In a the design of an interface, you have to choose the way in which to proceed by choosing a Integration Loading Strategies : IKM SQL Incremental...
Odi Cdc
ODI - Change Data Capture

The goal of Change Data Capture is to track change in the source data. When running integration interface, ODI-EE can reduce the volume of source data processed in the flow by extracting only the changed...
Card Puncher Data Processing
ODI - Check Knowledge Module (CKM)

The flow control strategy lets you define the method used to check the flow before the insertion in the target. It's defined in an interface by a Knowledge Module, the Check Knowledge Module (CKM) as :...
Card Puncher Data Processing
ODI - Datastore (Source and Target)

A datastore is a structure that allows data to be stored. It can be : a table, a file, a message queue or any other data structure accessible by middleware used by Oracle Data Integrator (JDBC/ODBC,...
Odi Designer
ODI - Designer

Through the Designer module, you can handle: Models: The data models for your applications: all of the metadata in your data servers : tables, columns, constraints, descriptions, cross-references,...
Odi Designer Interface Lkm
ODI - Loading Knowledge Module (LKM)

They are used to extract data from the sources. In a the design of an interface, you have to choose the way in which to proceed by choosing a Data Loading Strategies : LKM File to SQL LKM SQL to...
Card Puncher Data Processing
ODI - Log / Debug

The trick is here is to use an rdbms logical schema as the staging area (e.g. sql server, oracle). Set the interface not to delete the temporary target. Run the interface, the first step will be to...
Card Puncher Data Processing
ODI - Packages

A package is a pre-defined sequence of steps, designed to be executed in order. There are many types of steps, such as: Interfaces Procedures Actions/evaluations on variables Actions on models,...
Odi Project
ODI - Project

A project is a group of objects developed using Designer and is the first thing to do when you begin to design. Oracle...



Share this page:
Follow us:
Task Runner