1 / 93

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.

london
Download Presentation

Oracle Warehouse Builder 10.2 - Click by Click

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

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

  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

  4. OWB 9i OWB 10gR2 10gR2 Banner

  5. 10gR2 Banner

  6. Log into Design Center

  7. New Design Center Layout Tool Bar Connection Pane Project Explorer Pane Global Explorer Pane

  8. Highlight Project Area

  9. Expand Databases Project Expands

  10. Expand Oracle Available Databases

  11. Expand PeopleSoft Logical Oracle Content Areas

  12. Expand Mappings Module Components

  13. Warehouse Cycle of Mappings

  14. Open Satellite Mapping

  15. Mapping We Plan to End Up With

  16. Mapping Flow Unique Key Generator Join Tables Source Tables Target Table Transformations Key Lookup

  17. End Result

  18. Joining Tables With 10.2

  19. HUB ODS Join ODS and Hub Tables JOIN OBJECT

  20. Select Joiner from Palette

  21. Joiner Object

  22. Connect Source Fields to Joiner Object

  23. Open Details to Name

  24. Common Field Names given _1

  25. Give Join a Name and Description

  26. Build Join Conditions Joiner Properties Palette

  27. Pick Fields from Input 1 and 2

  28. Creating a Key Lookup

  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

  30. Select Key Lookup

  31. Key Lookup Wizard

  32. Defaults to “key lookup”

  33. Enter Meaningful Object Name

  34. Enter Purpose of Lookup

  35. Input and Output Step

  36. Minimum: Enter Short Description

  37. List of Objects on the Mapping List of Possible Sources

  38. Select ‘Join’ Object Select the Source

  39. Open Join Output Group

  40. Use Scroll Bar to Find Field(s)

  41. Click on Choice

  42. Click Transfer Arrow

  43. Business Unit Code Moved

  44. Search for Table to Use for Lookup

  45. Click on Selection

  46. Primary or Natural Key Fields in Lookup Table Join Object Fields for Equal Join Match Sides of Equijoin

  47. Default Passes Nulls as Output, Or you enter default values field by field What Happens With No Match?

  48. About Finished

  49. Summary of the Key Lookup Process

  50. Key Lookup Ready to Pass Data

More Related