OWB 11gR2 – Oracle By Examples

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.

Comments:

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

Posted by Chris on September 16, 2011 at 01:42 AM PDT #

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

Posted by David on September 16, 2011 at 03:26 AM PDT #

Hi,

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.

Thanks,

N. S.

Posted by N S on March 04, 2012 at 04:14 AM PST #

Hi

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.

Cheers
David

Posted by David on March 05, 2012 at 10:17 AM PST #

Some other useful posts;
http://gerardnico.com/wiki/dw/etl/owb/operator/pre-mapping_process_operator

Cheers
David

Posted by David on March 05, 2012 at 10:43 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today