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, and the OWB set are under 'Business Intelligence and Data Warehousing' then 'Warehouse Builder':
- Improved User Interface, Usability, and Productivity With OWB 11g R2
- Handling Flat File and COBOL Copybook Sources in Mappings
- Using Data Transformation Operators with Source and Target Operators
- Working with Pluggable Mappings
- Examining Source Data Using Data Profiling
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.
