Oracle Data Integrator First Mapping

First mapping one, creating "project"

Designer-Projects, click the Insert item icon,

In the Project dialog box, under the Definition tab, enter the project name, such as SAKILA_DWH, 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

Step1 right-click mappings → new mappings

STEP2 Drag the Model actor and Dim_actor to the mapped edit panel from model Sakila and SAKILA_DWH respectively

Step3 the output node of the source table actor's output node and the target table Dim_actor, if the property match prompt matches automatically by name, click OK

At this point, the actor_id property of the two tables has been mapped, the arrows in front of the dim_actor become darker, and the actor_id background of the Dim_actor actor_id,actor table will turn red.

STEP4 continues to drag the fitst_name,last_name,last_update of the ACTOR watch to Dim_actor actor_fitst_name, Actor_last_name, Actor_last_ The Update property. Save and verify

Because the actor_key is self-growing by the database maintenance ID, it can be ignored

Click on target datastore to display the mapping situation

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

After clicking,

STEP5 Modify the constraints of the dim_actor, increase the actor_id set to the substitution key, the reverse generation only generates the primary key constraints

STEP6 Logical tab page, check dim_actor, set integration type to incremental update, UPDATE keyword as new override key, constraint primary key Pk_dim_actor_key false

STEP7 The Logical tab page, set the primary key of the target table Dim_actor actor_key non-empty check check box unchecked

STEP8 Physical tab page, set lkm for lkm SQL to Oracle for intermediate modules

STEP9 Physical tab page, set target table Dim_actor integration Knowledge Module ikm for ikm Oracle Incremental update

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 "SAKILA_DWH". " Dim_actor ";

Continue inserting a piece of data in the source table actor

INSERT  into " SAKILA". " ACTOR "(" First_Name "," last_name "," last_update ")VALUES(' Zhang San ' , ' Zhang San ' , sysdate);

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

At this point, a complete mapping is completed.

Oracle Data Integrator First mapping