Oracle warehouse builder 10 2 click by click
Download
1 / 93

Oracle Warehouse Builder 10.2 - Click by Click - PowerPoint PPT Presentation


  • 140 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle Warehouse Builder 10.2 - Click by Click' - dasha


An Image/Link below is provided (as is) to download presentation

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.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Oracle warehouse builder 10 2 click by click

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


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.

DISCLAIMER


Building a mapping of peoplesoft data
Building a Mapping of PeopleSoft Data 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.

  • Join Two Tables

  • Build a Key Lookup

  • “Clean” or Transform Data with an Expression

  • Upsert Target Table with Results

  • Deploy and Run Mapping


10gr2 banner

OWB 9i 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.

OWB 10gR2

10gR2 Banner


10gr2 banner1
10gR2 Banner 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.


Log into design center
Log into Design Center 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.


New design center layout
New Design Center Layout 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.

Tool Bar

Connection Pane

Project Explorer Pane

Global Explorer Pane


Highlight project area
Highlight Project Area 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.


Project expands

Expand Databases 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.

Project Expands


Available databases

Expand Oracle 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.

Available Databases


Logical oracle content areas

Expand PeopleSoft 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.

Logical Oracle Content Areas


Module components

Expand Mappings 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.

Module Components


Warehouse cycle of mappings
Warehouse Cycle of Mappings 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.


Oracle warehouse builder 10 2 click by click

Open Satellite Mapping 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.


Mapping we plan to end up with
Mapping We Plan to End Up With 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.


Mapping flow
Mapping Flow 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.

Unique Key Generator

Join Tables

Source Tables

Target Table

Transformations

Key Lookup


End result
End Result 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.


Joining tables with 10 2
Joining Tables With 10.2 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.


Join ods and hub tables

HUB 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.

ODS

Join ODS and Hub Tables

JOIN OBJECT


Select joiner from palette
Select Joiner from Palette 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.


Joiner object
Joiner Object 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.


Connect source fields to joiner object
Connect Source Fields to Joiner Object 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.


Open details to name
Open Details to Name 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.


Common field names given 1
Common Field Names given 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. _1


Give join a name and description
Give Join a Name and Description 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.


Build join conditions
Build Join Conditions 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.

Joiner Properties Palette


Pick fields from input 1 and 2
Pick Fields from Input 1 and 2 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.


Creating a key lookup
Creating a Key Lookup 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.


Purpose of key lookup
Purpose of Key Lookup 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.

  • Another Way to Join to a Table

  • Primary use is to provide values from Table of Values

  • Use when an Equijoin may eliminate rows


Select key lookup
Select Key Lookup 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.


Key lookup wizard
Key Lookup Wizard 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.


Defaults to key lookup
Defaults to “key lookup” 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.


Enter meaningful object name
Enter Meaningful Object Name 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.


Enter purpose of lookup
Enter Purpose of Lookup 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.


Input and output step
Input and Output Step 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.


Minimum enter short description
Minimum: Enter Short Description 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.


List of possible sources

List of Objects on the Mapping 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.

List of Possible Sources


Select the source

Select ‘Join’ Object 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.

Select the Source


Open join output group
Open Join Output Group 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.


Use scroll bar to find field s
Use Scroll Bar to Find Field(s) 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.


Click on choice
Click on Choice 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.


Click transfer arrow
Click Transfer Arrow 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.


Business unit code moved
Business Unit Code Moved 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.


Search for table to use for lookup
Search for Table to Use for Lookup 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.


Click on selection
Click on Selection 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.


Match sides of equijoin

Primary or Natural Key Fields in Lookup Table 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.

Join Object Fields for Equal Join

Match Sides of Equijoin


What happens with no match

Default Passes Nulls as Output, Or you enter default values field by field

What Happens With No Match?


About finished
About Finished field by field







Validate mapping
Validate Mapping field by field



Data transformation
Data Transformation field by field


Use of expressions
Use of Expressions field by field

  • “Clean” the Data, handle nulls, etc.

  • Conform the Data – all CAPS, etc

  • Conditional Logic – if then else

  • Dig out data from strings – Substring

  • Etc


Populate expression
Populate Expression field by field


Expression output
Expression Output field by field


Edit output fields
Edit Output Fields field by field


Common expression transforms
Common Expression Transforms field by field

  • 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


Define expressions

Highlight Field field by field

Define Expressions


Expression builder popup

Validate Logic field by field

Accept Expression Click OK

Expression Builder Popup

Build Transform Logic


Connect output to next object

Expand Target Object field by field

Connect Output to Next Object





Generating unique keys
Generating Unique Keys field by field



Sequence near bottom of palette

Use Scroll Bar, Drag and Drop Sequence Object field by field

Sequence Near Bottom of Palette



Select next value
Select Next Value field by field



Define output result
Define Output Result field by field


Set operation on target table

Expand Loading Type field by field

Set Operation on Target Table


Loading alternatives

Select Upsert field by field

Loading Alternatives


Set record upsert match

Expand Constraint for Options field by field

Set Record Upsert Match


Oracle warehouse builder 10 2 click by click

Select Natural Key field by field



Deploy and run mapping
Deploy and Run Mapping field by field


Deploy from control center

Click On Tools field by field

Deploy From Control Center


Deploy and run control

Select Control Center Manager field by field

Deploy and Run Control


Configure the running

Right Click field by field

Configure the Running


Run configuration

Select Configure field by field

Run Configuration


Operating mode

Select Operating Mode field by field

Operating Mode


Run in set or row based mode

Select Row Based field by field

Run in Set or Row Based Mode


Oracle warehouse builder 10 2 click by click

Click Default field by field

Changed

None


Oracle warehouse builder 10 2 click by click

Deploy field by field

Changed


Generate the mapping script

Generating PL/SQL Script field by field

Generate the Mapping Script


Mapping executing

Running PL/SQL Script field by field

Mapping Executing


Executing the mapping

Executing the Mapping field by field

Executing the Mapping


Job completed
Job Completed field by field


Questions
Questions? field by field

Jim Raper

Data Administration Manager

City of Charlotte

600 E. 4th Str

Charlotte, NC 28202

704 336 8068

jraper@ci.charlotte.nc.us