Oracle Warehouse Builder 10.2 - Click by Click. February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte email@example.com.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Oracle Warehouse Builder 10.2 - Click by Click February 8, 2007 Jim Raper Data Administration Manager BSS/IT City of Charlotte firstname.lastname@example.org
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. DISCLAIMER
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
OWB 9i OWB 10gR2 10gR2 Banner
New Design Center Layout Tool Bar Connection Pane Project Explorer Pane Global Explorer Pane
Expand Databases Project Expands
Expand Oracle Available Databases
Expand PeopleSoft Logical Oracle Content Areas
Expand Mappings Module Components
Mapping Flow Unique Key Generator Join Tables Source Tables Target Table Transformations Key Lookup
HUB ODS Join ODS and Hub Tables JOIN OBJECT
Build Join Conditions Joiner Properties Palette
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
List of Objects on the Mapping List of Possible Sources
Select ‘Join’ Object Select the Source
Primary or Natural Key Fields in Lookup Table Join Object Fields for Equal Join Match Sides of Equijoin
Default Passes Nulls as Output, Or you enter default values field by field What Happens With No Match?