Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'Data Integration'
OWB 11gR2 - Subquery
One of the new mapping operators introduced in 11gR2 is the much talked about (over the years) subquery filter operator. As well as the heterogeneous capabilities added, a number of enhancements to existing operators (such as joiner and lookup operator)...
OWB 11gR2 – Template mapping variables?
Here we'll see how you can add runtime variables and reference them from code template mappings in OWB 11gR2; variables can be used in many places including expressions, filters, joiners and execution unit code template assignments. This lets you control...
OWB 11gR2 – Cube Organized Materialized Views
Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo,...
OWB 11gR2 – Bulk File Loading - more, faster, easier
A common problem in warehouses is to load a number of similar files into the database, often the filenames are dynamic so the names cannot be hard-wired, if they are known its easy enough to configure the external table or...
OWB 11gR2 – Architecture Overview
This post gives an overview of the OWB 11gR2 code template framework and runtime infrastructure, the code template framework is a key component in the product's customization and open connectivity capabilities. This framework enables OWB to integrate much more data...
OWB 11gR2 – Trickle Feed Data Acquisition and Delivery
The OWB 11gR2 release introduced near real time data warehousing capabilities. OWB has been enhanced to also support a continuous trickle feed loading approach by introducing the concept of trickle feed mappings. A trickle feed mapping is a mapping with...
Oracle Warehouse Builder 11gR2
Great news, today Oracle released the Linux x86 and x86-64 versions of 11gR2 for the Oracle Database which includes Warehouse Builder (see Oracle Database 11gR2 here). Nice to finally see all the hard work eventually come to fruition. This has...
Matching Abbreviations and Acronyms
A quick post on how to match data using composite match rules for matching abbreviations or matching acronyms. For example we want to match the following tokens; International Business Machines Intl Bus Machines IBM One of these is a full...
Pattern Matching Conditions
The Oracle database has a range of powerful regular expression based pattern matching functions that can be used to filter and match data, in OWB for example conditions can be used in many places such as filters and joins. This...
Parallel Unload to File
Here we see how to to construct a parallel unload mapping leveraging the Oracle Database parallel table function capabilities to write the results from a PLSQL Ref Cursor to file. The example also illustrates how the table function arguments are...
Writing Master Detail Files
I've seen this question a few times about how to write a master detail file using OWB, so thought a quick post was in order. Here you'll see a technique for writing such files and using the union all and...
Book: Getting Started with OWB 11g
Just got a note on this new book on OWB 11g. Might be a great resource for those working on OWB to augment the user documentation and see someone else's take on the OWB world. Book is here: http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g/book Enjoy!...
Why does it take forever to build ETL processes
ETL is a lengthy process... what can you do about it?
File staging using external table preprocessor
Here is a quick write up of how to take advantage of the external table preprocessor feature which was squeezed into the 11.1.0.7 and 10.2.0.5 database patch sets from within OWB. OWB has rich metadata support for file design and...
Headless Operation – OWB code generation, going it alone
There are a few different implementation scenarios for moving designs from OWB into an execution environment, out of the box OWB has a runtime service component which supports deployment and execution of all of OWB's design objects. The standard deployment...
Process Flow Variables – To Quote or Not To Quote
Here is some information on the process flow variable literal quote or not quote query. Its not exactly intuitive, so hopefully this helps! The flow designer has to know what is a PLSQL activity and what is not. Process flow...
Expert: Useful scripts from simple primitives
Here is a useful OMB scripting example to illustrate the basic mechanics of the OMB scripting grammar to create an expert. The expert has a couple of steps to get information from the user to load an object (file, table...
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...
OWB and DW @ Oracle Openworld
Tickets are booked, hotels are reserved, excitement is building... yes it is time for Oracle OpenWorld! As data warehouse and OWB enthusiasts we all want to know the best sessions to go to. Here is a useful PDF printable booklet...
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...
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 Integration'.
