oracle warehouse builder 10 2 click by click n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Warehouse Builder 10.2 - Click by Click PowerPoint Presentation
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


  • 164 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

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