Welcome to All Things Warehouse Builder

OWB 11gR2 – Oracle By Examples

David Allan

There are a number of OBEs available for the OWB 11gR2 release which range from an overview of all the cool new usability improvements in the mapping editor (auto-mapping improvements, copy-paste expressions, operators, operator groups, group/ungroup operators, spotlighting to name a few!), through basics of using the operators in a mapping for joining, filtering, pivoting and so on, then diving into building pluggable mappings (aiding reusability and good software design practice)  and last but not least an OBE on data profiling covering profiling, deriving rules and even cleansing the data!

The entire Oracle OBE 11gR2 release OBE's are here(or search for OWB):

There are some interesting examples here, worth checking out to see some of the cool new features and existing ones that illustrate the capabilities! In the 11gR2 set there are other interesting posts well worth checking out such as the High Speed Data Loading and Rolling Window Operations with Partitioning post, all essential information for leveraging the database to the max in your ETL loads.

Join the discussion

Comments ( 5 )
  • Chris Friday, September 16, 2011

    http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO is no longer working. Please update. It is the link in the following sentence: The entire Oracle OBE 11gR2 release OBE's are here

  • David Friday, September 16, 2011

    I have fixed the URL, the specific links were also working. Also you can search for the string OWB to get OWB OBEs.

  • N S Sunday, March 4, 2012


    I am new in OWB and would like to create a post-map in an existing map.

    Could you please provide me some step-by-step guideline to create that ?

    Please note : I am having a DB procedure which I would like to call as a post-map.


    N. S.

  • David Monday, March 5, 2012


    There are pre and post map customization points where you can call a PLSQL function or procedure.

    For pre map customization use the 'Pre-Mapping Process'. With this operator based upon its result the rest of the mapping can be conditionally executed. Use the property 'Mapping Run Condition' to determine whether the body of the map should be executed, by default this property has value SUCCESS, so only if the routine completes successfully will the body be executed.

    For post map customization use the 'Post-Mapping Process' operator. With this operator it can be conditionally executed based upon the result of the map body. The property 'Post-Mapping Process Run Condition' is defaulted to ON SUCCESS, but this can be changed to ALWAYS / ON ERROR / ON WARNING if desired.



  • David Monday, March 5, 2012
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.