Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'SQL'
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)...
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....
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...
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...
OWB Public Views in 11g Release 1
In OWB 11g the repository is a set of workspaces. In the public views this means you need to set the workspace context.This is not an issue from within a map as the workspace context is set prior to invoking...
Working in an SAP production environment with OWB
SAP is a bit different... it is more structured than most other environments and there are specific requirements on running ABAP programs in production systems. Since this is a common topic, and since we have a very nice solution (if...
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...
Table Functions as Source and Target
Using table functions is a useful way to both boost performance and extend the source/target capabilities in OWB. Here we will see how to setup table functions as a source and a target in OWB. Table functions let you define...
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...
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,...
Advanced Aggregation
The OWB 10.2.0.3 and 11g releases of OWB extended the aggregation capabilities to support Oracle's advanced aggregation capabilities. So for example the CUBE and ROLLUP clauses can now be used in the aggregation operator which is great for building summary...
Leveraging XDB
I've been meaning to post details on leveraging XDB from OWB for some time, so finally here we go. This note is intended to provide an overview of how to build transformations of XML related objects within OWB 10gR2, it...
SQL and OWB - Accelerated Map Construction? Part 2
Regarding reverse engineering OWB maps from SQL (see earlier post here), I've uploaded the expert as stands, it is a demo remember with no support contract:) It will be useful for people to see a range of OMB related to...
Set based errors - DML Error Logging
Error logging enables the processing of DML statements to continue despite errors being encountered during the statement execution. The details of the error such as the error code and the associated error message are stored in an error table. After...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'SQL'.
