Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'data warehouse'
Why does it take forever to build ETL processes
ETL is a lengthy process... what can you do about it?
Interesting Blog on Data Warehousing
Well, not sure if anyone missed my posts on this blog, but recently I moved myself onto a new blog. We have started a more generic data warehousing blog, which focusses on the actual database platform, rather than on tools....
Oracle Warehouse Builder for SAP ETL: OWB SAP Application Connector
The OWB SAP connector has been around for several releases now and is a mature product being used successfully by many OWB customers. However, the public documentation on the connector has been rather sparse and in need of a refresh... We recently updated the material to provide a lot more detail on how the connector works and how to use it. You can get the full details here, in the OWB Connector for SAP documentation.
Want to learn more about the HP Oracle Database Machine?
Here is your chance, sign up now to attend the Oracle BIWA Summit 2008 Dec. 2-3. Attend this unique two-day IOUG Business Intelligence, Warehousing and Analytics (BIWA) SIG (www.oraclebiwa.org) event to gain the knowledge and information critical for success in...
Sizing an OWB system...
Should I even go here...? Maybe not, but one thing that I thought would be interesting to mention here is an avenue to take when you are struggling with sizing. Yes, this will have loads of disclaimers but might be...
DBLinks the sequel
Did the #2 option today on an 11g database (just to remind me that things are different in 11g). The simple way of getting OWB to use a dblink is to create your own connector (you may have to delete...
Using a DBLink Location for ETL
One of the things that might be interesting to have a play with is the ability to use a predefined dblink as a substitute for the OWB db links generated when you create two locations pointing to two separate hosts....
Full Outer Joins in OWB
One of the questions I noticed recently was on full outer joins. How do you do that in OWB. Well it is quite simple, but I guess not that obvious. So here is a quick post on how to do...
Modifying icons for process flow activities
I would guess many people are using user defined activities in process flow. As do we when we do partner work. Wouldn't it be nice if you could change the icons for the user defined activities to better show what...
OWB, web services and the database
Since we get this question quite often, lets go back into this a little more. What is the story with OWB (or better the database) and web services? Well, you have all the tools and mechanisms around to simply hook...
Data Watch and Repair for Master Data Management
Some happy news on the data quality front (yes I'm harping on that quite a bit these days...). We just completed the new Data Watch and Repair solution using the entire OWB technology stack. One of the things we phased...
Checking referential integrity with data rules
So you read my KQIs thingie. This one is a bit more practical in that it is real code without coding :-)I get incoming data into a table, and what I want to do is check referential integrity without FKs,...
Manual intervention in a process flow (restart, retry or reroute): Part I
As a follow up on the emailing errors from process flows, this post looks at using the Manual activity in the process flow editor to choose a path interactively. If you combine this post with the emailing post, you basically...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'data warehouse'.
