Oracle Data Integrator 12c-First mapping

Source: Internet
Author: User

First, create " Project "

Designer-Projects, click the Insert item icon,

In the Project dialog box, under the Definition tab, enter the project name, such as Odi_exercise, to save

second, import knowledge module

Project → knowledge module → Right-click import Knowledge Module

File import Directory: Oracle\middleware\oracle_home\odi\sdk\xml-reference

Reverse Engineering Knowledge Module (RKM)

RKM Oracle

Load Knowledge Module (LKM)

LKM SQL to Oracle

Inspection Knowledge Module (CKM)

CKM Oracle

Integrated Knowledge Module (IKM)

IKM Oracle Incremental Update

The Diary Knowledge Module (JKM) is not available

JKM Oracle Consistent

JKM Oracle Simple

Service Knowledge Module (SKM) is not available

SKM Oracle

Iii. Creating and configuring Mappings 3.1 New Interface

Right-click mappings → new mappings

3.2 Designing a data source-to-target mapping

Drag the Model dept from model ODI_SRC and Odi_tag to the mapped edit panel, respectively

Connect the output node of the source table dept to the output node of the target table dept, if the property match prompts to automatically match by name, click OK (you can also drag the source field to the destination table field, or edit the property panel expression of the target marker segment)

At this point, the individual field properties of the two tables have been mapped, a field in the target table is selected, and the field background of the source table is red.

Save and verify

Click on the target Datastore, and the properties panel can view the receivable.

There is a button at the back of the property panel expression to provide a graphical edit button

After clicking,

3.3 Select the appropriate knowledge module in the "Flow"

Logical tab page, select the target table, set the integration type to incremental update, update the keyword as the constraint primary key pk_dept

Physical tab page, set the lkm of the intermediate module to lkm SQL to Oracle

Physical tab page, set the integration knowledge module of the target table ikm for ikm Oracle Incremental update

3.4 "execute" mapping, using operator to correct the interface

Click on the toolbar green to perform the mapping, in the actions → session list → View the execution results

Go to database query results

SELECT *  from "Odi_tag". " DEPT ";

Continue inserting a piece of data in the source table actor

INSERT  into VALUES ('the 'IT''BOSTON');

Perform the mapping and find the ability to synchronize the new records

At this point, a complete mapping is completed.

Oracle Data Integrator 12c-First mapping

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.