oracle warehouse builder 10 2 click by click
Download
Skip this Video
Download Presentation
Oracle Warehouse Builder 10.2 - Click by Click

Loading in 2 Seconds...

play fullscreen
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 [email protected]

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

[email protected]

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
  • Join Two Tables
  • Build a Key Lookup
  • “Clean” or Transform Data with an Expression
  • Upsert Target Table with Results
  • Deploy and Run Mapping
new design center layout
New Design Center Layout

Tool Bar

Connection Pane

Project Explorer Pane

Global Explorer Pane

mapping flow
Mapping Flow

Unique Key Generator

Join Tables

Source Tables

Target Table

Transformations

Key Lookup

build join conditions
Build Join Conditions

Joiner Properties Palette

purpose of key lookup
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
use of expressions
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
common expression transforms
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
expression builder popup

Validate Logic

Accept Expression Click OK

Expression Builder Popup

Build Transform Logic

slide87

Click Default

Changed

None

slide88

Deploy

Changed

questions
Questions?

Jim Raper

Data Administration Manager

City of Charlotte

600 E. 4th Str

Charlotte, NC 28202

704 336 8068

[email protected]

ad