The pivot transformation operator enables you to transform a single row of attributes into multiple rows in an efficient manner. This example illustrates...
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 with a row for each quarter. The OWB pivot operator makes this simple (there is also an unpivot).So taking a simple example as follows:YEAR Q1_sales Q2_sales Q3_sales Q4_sales---------- ---------- ---------- ---------- ---------- ...
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...
Some more cool stuff in 11g, the Gateways install has a lightweight remote/scheduler agent for executing tasks such as native unloaders or any custom activity....
Some more cool stuff in 11g, the Gateways install has a lightweight remote/scheduler agent for executing tasks such as native unloaders or any custom activity. This follows on from the post on the 11g Heterogeneous Agent, and the agent is installed from the software downloaded in that post.The setup and configuration is fairly simple but is kind of scattered across a few manuals, here is a simple example that steps through executing a batch script on a Windows system from an...
Some more cool stuff in 11g, the Gateways install has a lightweight remote/scheduler agent for executing tasks such as native unloaders or any custom activity. This follows on from the post on the...
So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support...
So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the vast majority of cases. I guess it is not 100% obvious though how it is done, especially from the queries on mailing lists and forums. Once you see the pattern then it becomes apparent what the tasks at hand are. I created a viewlet (see here) which uses a nice small example to illustrate...
So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the...
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...
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 maps with these simple yet powerful clauses.To illustrate I have used the example from the Oracle Data Warehousing guide (Example 20-8 GROUPING combined with HAVING);SELECT...
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...
There are quite a few nice changes in the 11g Gateways that are worth checking out.... from performance to standalone agent to legacy integration. As with a lot...
There are quite a few nice changes in the 11g Gateways that are worth checking out.... from performance to standalone agent to legacy integration. As with a lot of things in life, when you start scratching the surface you find lots of cool and interesting stuff - and in amongst a few things you don't want to find too of course! Here's a few initial findings on setup.... The software firstly for 11g is under the 'See All' section next to the database platform download. When...
There are quite a few nice changes in the 11g Gateways that are worth checking out.... from performance to standalone agent to legacy integration. As with a lot of things in life, when you...
According to a new press release, world-leading aluminum producer Alcoa has adopted Oracle Database, Oracle Real Application Clusters, and Oracle Warehouse...
According to a new press release, world-leading aluminum producer Alcoa has adopted Oracle Database, Oracle Real Application Clusters, and Oracle Warehouse Builder for constructing a multi-terabyte global data warehouse, as a better alternative for their long-term needs, following "a thorough evaluation of Oracle and a third-party database platform provider." From the release:With its GDW, Alcoa's business and corporate executives are able to access, manage and integrate...
According to a new press release, world-leading aluminum producer Alcoa has adopted Oracle Database, Oracle Real Application Clusters, and Oracle Warehouse Builder for constructing a multi-terabyte...
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...
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 is intended to give a brief overview of what can be achieved and by no means is it a definitive list of capabilities (see the XML DB Developer's Guide for a complete reference). It cross-references a few examples constructed in the XML DB Developer's Guide...
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...
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...
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 map construction as well as illustrating some of the SQL to OWB potential. Some of the demo SQL below requires the OWB 10.2.0.3 patch since there were improvements and fixes in the aggregator operator that allow you to use the CUBE/ROLLUP functions and...
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...
In a multi step mapping here is an approach to determine the status of steps within the map and control processing.If you have 2 steps in a map step A and B,...
In a multi step mapping here is an approach to determine the status of steps within the map and control processing.If you have 2 steps in a map step A and B, after each step in your map you can add another step which checks thestatus of the previous step and based on acondition does what you need. This concept is based on a set based (pure SQL map) and also the dependency on step result status is based on the OWB runtime audit trail, so if you do not use the audit trail, this...
In a multi step mapping here is an approach to determine the status of steps within the map and control processing.If you have 2 steps in a map step A and B, after each step in your map you can...