Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'ELT'
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...
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...
Data types - using complex data types in ETL
Not sure this is a widely known fact, but one of the changes we made in OWB 10.2 (and up of course) is the extensive support for complex Oracle data types. Areas such as spatial data will benefit from this...
Comments, questions and the forum
When going through the blog I noticed some comments actually are questions. Not sure if everyone knows, but there is a very active product forum on OTN. The link has changed over the past couple of weeks, so make sure...
SQL for workspace enablement
As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or SQL Plus: begin owbsys.wb_workspace_management.set_workspace('workspacename', 'workspaceowner'); owbsys.start_enable_owb_roles; end; Replace the italics for workspacename and...
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...
Performance tuning mappings
You can leverage the standard Oracle tuning tools for investigating set based SQL performance and PLSQL performance. There are reports in the utility exchange (see here) for reporting on the results after using the DBMS_PROFILER.The PLSQL profiles can be queried...
Pivoting Data in OWB
The pivot transformation operator enables you to transform a single row of attributes into multiple rows in an efficient manner. This example illustrates transforming a table that has a row for each year with the quarterly sales in a table...
Manual intervention in a process flow (restart, retry or reroute): Part II
Doing the actual "go back after I did something" is very simple. I've extended and changed the process flow used in the previous post (part I) to look like this:Essentially I have some execution part (my silly procedure which insert...
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 'ELT'.
