![Page 1: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/1.jpg)
1
Oracle Warehouse Builder 10.2 - Click by Click
February 8, 2007
Jim RaperData Administration Manager
BSS/ITCity of Charlotte
![Page 2: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/2.jpg)
2
DISCLAIMER
The views and opinions presented in this paper are solely those of the Author and do not necessarily reflect those of Business Support Services Information Technology Division or of the City of Charlotte. This material is provided for informational purposes only. City of Charlotte assumes no responsibility for accuracy of the information in this paper or from damages caused by implemented the techniques or methodologies presented herein.
![Page 3: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/3.jpg)
3
Building a Mapping of PeopleSoft Data
• Join Two Tables
• Build a Key Lookup
• “Clean” or Transform Data with an Expression
• Upsert Target Table with Results
• Deploy and Run Mapping
![Page 4: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/4.jpg)
4
10gR2 Banner
OWB 9i
OWB 10gR2
![Page 5: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/5.jpg)
5
10gR2 Banner
![Page 6: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/6.jpg)
6
Log into Design Center
![Page 7: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/7.jpg)
7
New Design Center Layout
Project Explorer Pane
Connection Pane
Global Explorer
Pane
Tool Bar
![Page 8: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/8.jpg)
8
Highlight Project Area
![Page 9: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/9.jpg)
9
Project Expands
Expand Databases
![Page 10: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/10.jpg)
10
Available Databases
Expand Oracle
![Page 11: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/11.jpg)
11
Logical Oracle Content Areas
Expand PeopleSoft
![Page 12: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/12.jpg)
12
Module Components
Expand Mappings
![Page 13: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/13.jpg)
13
Warehouse Cycle of Mappings
![Page 14: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/14.jpg)
14
Open Satellite Mapping
![Page 15: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/15.jpg)
15
Mapping We Plan to End Up With
![Page 16: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/16.jpg)
16
Mapping Flow
Key Lookup
Transformations
Target Table
Unique Key Generator
Join Tables
Source Tables
![Page 17: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/17.jpg)
17
End Result
![Page 18: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/18.jpg)
18
Joining Tables With 10.2
![Page 19: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/19.jpg)
19
Join ODS and Hub Tables
JOIN OBJECT
HUB
ODS
![Page 20: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/20.jpg)
20
Select Joiner from Palette
![Page 21: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/21.jpg)
21
Joiner Object
![Page 22: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/22.jpg)
22
Connect Source Fields to Joiner Object
![Page 23: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/23.jpg)
23
Open Details to Name
![Page 24: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/24.jpg)
24
Common Field Names given _1
![Page 25: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/25.jpg)
25
Give Join a Name and Description
![Page 26: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/26.jpg)
26
Build Join Conditions
Joiner Properties Palette
![Page 27: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/27.jpg)
27
Pick Fields from Input 1 and 2
![Page 28: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/28.jpg)
28
Creating a Key Lookup
![Page 29: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/29.jpg)
29
Purpose of Key Lookup
• Another Way to Join to a Table
• Primary use is to provide values from Table of Values
• Use when an Equijoin may eliminate rows
![Page 30: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/30.jpg)
30
Select Key Lookup
![Page 31: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/31.jpg)
31
Key Lookup Wizard
![Page 32: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/32.jpg)
32
Defaults to “key lookup”
![Page 33: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/33.jpg)
33
Enter Meaningful Object Name
![Page 34: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/34.jpg)
34
Enter Purpose of Lookup
![Page 35: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/35.jpg)
35
Input and Output Step
![Page 36: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/36.jpg)
36
Minimum: Enter Short Description
![Page 37: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/37.jpg)
37
List of Possible Sources
List of Objects on the Mapping
![Page 38: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/38.jpg)
38
Select the Source
Select ‘Join’ Object
![Page 39: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/39.jpg)
39
Open Join Output Group
![Page 40: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/40.jpg)
40
Use Scroll Bar to Find Field(s)
![Page 41: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/41.jpg)
41
Click on Choice
![Page 42: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/42.jpg)
42
Click Transfer Arrow
![Page 43: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/43.jpg)
43
Business Unit Code Moved
![Page 44: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/44.jpg)
44
Search for Table to Use for Lookup
![Page 45: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/45.jpg)
45
Click on Selection
![Page 46: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/46.jpg)
46
Match Sides of Equijoin
Primary or Natural Key Fields in Lookup Table Join Object Fields for Equal Join
![Page 47: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/47.jpg)
47
What Happens With No Match?
Default Passes Nulls as Output, Or you enter default values field by field
![Page 48: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/48.jpg)
48
About Finished
![Page 49: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/49.jpg)
49
Summary of the Key Lookup Process
![Page 50: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/50.jpg)
50
Key Lookup Ready to Pass Data
![Page 51: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/51.jpg)
51
Drag and Drop Connection -1
![Page 52: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/52.jpg)
52
Drag and Drop Connection - 2
![Page 53: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/53.jpg)
53
Drag and Drop Connection -3
![Page 54: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/54.jpg)
54
Validate Mapping
![Page 55: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/55.jpg)
55
Validation Completed Successfully
![Page 56: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/56.jpg)
56
Data Transformation
![Page 57: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/57.jpg)
57
Use of Expressions
• “Clean” the Data, handle nulls, etc.
• Conform the Data – all CAPS, etc
• Conditional Logic – if then else
• Dig out data from strings – Substring
• Etc
![Page 58: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/58.jpg)
58
Populate Expression
![Page 59: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/59.jpg)
59
Expression Output
![Page 60: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/60.jpg)
60
Edit Output Fields
![Page 61: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/61.jpg)
61
Common Expression Transforms
• Trim off Blanks from character fields TRIM(INGRP1.CHAR_FLD_NAME)
• Select portions of fields SUBSTR(INGRP1.NUMBER_FLD_NAME,1,5)
• Handle Null Values NVL(INGRP1.FLD_NAME,’U’)
• Convert to Upper Case UPPER(INGRP1.FLD_NAME)
• Convert Characters to Numbers TO_NUMBER(INGRP1.FLD_NAME)• If … then …Else Logic
CASE Statement• Compound Expressions and Functions
![Page 62: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/62.jpg)
62
Define Expressions
Highlight Field
![Page 63: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/63.jpg)
63
Expression Builder Popup
Build Transform Logic
Validate Logic
Accept Expression Click OK
![Page 64: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/64.jpg)
64
Connect Output to Next Object
Expand Target Object
![Page 65: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/65.jpg)
65
Drag and Drop One Field at a Time
![Page 66: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/66.jpg)
66
Drag and Drop All at Once
![Page 67: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/67.jpg)
67
Expression Mapped to Target
![Page 68: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/68.jpg)
68
Generating Unique Keys
![Page 69: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/69.jpg)
69
Satellite Table Needs Unique PK
![Page 70: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/70.jpg)
70
Sequence Near Bottom of Palette
Use Scroll Bar, Drag and Drop Sequence Object
![Page 71: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/71.jpg)
71
Expand Sequence Generator
![Page 72: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/72.jpg)
72
Select Next Value
![Page 73: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/73.jpg)
73
Drag and Drop to Target Field
![Page 74: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/74.jpg)
74
Define Output Result
![Page 75: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/75.jpg)
75
Set Operation on Target Table
Expand Loading Type
![Page 76: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/76.jpg)
76
Loading Alternatives
Select Upsert
![Page 77: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/77.jpg)
77
Set Record Upsert Match
Expand Constraint for Options
![Page 78: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/78.jpg)
78
Select Natural Key
![Page 79: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/79.jpg)
79
Mapping is Ready to Deploy
![Page 80: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/80.jpg)
80
Deploy and Run Mapping
![Page 81: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/81.jpg)
81
Deploy From Control Center
Click On Tools
![Page 82: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/82.jpg)
82
Deploy and Run Control
Select Control Center Manager
![Page 83: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/83.jpg)
83
Configure the Running
Right Click
![Page 84: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/84.jpg)
84
Run Configuration
Select Configure
![Page 85: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/85.jpg)
85
Operating Mode
Select Operating Mode
![Page 86: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/86.jpg)
86
Run in Set or Row Based Mode
Select Row Based
![Page 87: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/87.jpg)
87
Changed None
Click Default
![Page 88: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/88.jpg)
88
Deploy Changed
![Page 89: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/89.jpg)
89
Generate the Mapping Script
Generating PL/SQL Script
![Page 90: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/90.jpg)
90
Mapping Executing
Running PL/SQL Script
![Page 91: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/91.jpg)
91
Executing the Mapping
Executing the Mapping
![Page 92: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/92.jpg)
92
Job Completed
![Page 93: 1 Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte jraper@ci.charlotte.nc.us](https://reader035.vdocuments.us/reader035/viewer/2022062519/56649ee75503460f94bf84af/html5/thumbnails/93.jpg)
93
Questions?
Jim RaperData Administration Manager
City of Charlotte600 E. 4th Str
Charlotte, NC 28202704 336 8068