-
Notifications
You must be signed in to change notification settings - Fork 1
/
create-execute-mappings.html
39 lines (29 loc) · 1.45 KB
/
create-execute-mappings.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Oracle Data Integrator (ODI) 12c Overview - Models and Datastores - Create and execute an ODI mapping</title>
</head>
<h3>Oracle Data Integrator (ODI) 12<em>c</em></h3>
<ul>
<li>Create and execute an ODI mapping</li></ul>
Order to create mappings:
<ol>
<li>Create a New Mapping</li>
<li>Adding and removing components</li>
<li>Connecting and configuring components</li>
<li>Defining a physical configuration</li>
<li>Run mapping</li>
</ol>
Open the logical diagram on the mapping editor and begin to build your mapping.
<ol>
<li>Design Navigator > Mappings node (under the project you want to create the mapping for) and right click New Mapping</li>
<li>Fill in the name, description, etc</li>
<li>Drag the components you need on to the staging area</li>
<li>Drag datastores/reusable mappings from the Design Navigator</li>
<li>Connect the components to create the data flow</li>
<li>Define the expressions and conditions by selecting the attribute you wish to define</li>
<li>For expressions click on the Target tab, for conditions click on the condition tab</li>
<li>Define the physical connection by going to the physical tab > define the loading and integration strategies</li>
<li>Run the mapping by right-clicking on the mapping from the Design Navigator and choosing Run</li>
</ol>