Tuesday Jan 24, 2012

ODI Time Generation – SQL as a Source

Came across a nice use of the earlier SQL as a Source KM posting where the source was a time dimension generator. The forum entry is here, so the temporary interface is a data generator which when nested can be used in an interface to merge or load into a target.

Click on the image to see more …

 

Nice way to capture within tool and leverage different integration KMs on the target.

Monday Jan 09, 2012

OWB 11gR2 - Dimensional Modeling Paper

At the recent DOAG conference in November 2011, Maren Eschermann from Trivadis presented a session on Dimensional Modeling with OWB 11gR2. Maren has kindly posted an English translation of the presentation and paper, both well worth reading where she provides some valuable opinions on the features and how to get the most from them.

There’s a lot of useful stuff in there, thank you for sharing Maren!

There were a lot of OWB sessions at DOAG, another interesting geographic statistic is from the ‘owbland’ Sourceforge project, if you look at the download statistics there have been 2300 downloads of files from that project in the past 14 months, not bad….good job Oleg. Also interesting statistics on the top countries with downloads, no surprises…Germany and Netherlands!

So quite some activity, if you get time have a read through the paper and presentation on Dimensional Modeling with OWB 11gR2, and thanks again Maren.

About

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

Search

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