MDM – Data Warehouse Interfaces MDM holds accurate authoritative governed dimension data, the actual operational data cross-reference, and the hierarchy information on all key master data objects. These represent the foundational interfaces between MDM and the DW. With all the master data in the MDM Hubs, only one pipe is needed into the data warehouse [...]
August 27th, 2010 | Posted in ORACLE BLOGS | No Comments
There has been some interest from customers about moving data from Oracle Healthcare Transaction Base(HTB) across into Oracle Healthcare Data Warehouse Foundations (HDWF). Yes, we have started moving data in this direction. I don’t believe that it is being done in production yet but our consulting group has setup a deployment that successfully moves data [...]
August 23rd, 2010 | Posted in ORACLE BLOGS | No Comments
Chapter 7: Oracle VM Networking from A to 802.1Q | ITNewsCast Oracle VM Networking from A to 802.1Q Chapter 7 covers the following topics: Oracle VM Networking Introduction Oracle VM Server Networking Oracle VM Guest Networking Oracle VM Server Networking Configuration Examples The Default ethX/x (tags: ping.fm) JavaOne and Oracle Develop Unconference (Oracle Develop Conference [...]
August 23rd, 2010 | Posted in ORACLE BLOGS | No Comments
Sometimes we talk about the details of Warehouse Builder functionality so much that it’s easy to forget to raise our heads from time to time, and look at the broader questions of data warehousing and business intelligence. But recently I was asked by a few different customers, who are already using Oracle and OWB, “Wait… [...]
August 20th, 2010 | Posted in ORACLE BLOGS | No Comments
Sometimes we talk about the details of Warehouse Builder functionality so much that it’s easy to forget to raise our heads from time to time, and look at the broader questions of data warehousing and business intelligence. But recently I was asked by a few different customers, who are already using Oracle and OWB, “Wait… [...]
August 20th, 2010 | Posted in ORACLE BLOGS | No Comments
Fortunately, my blogging activity is inversely proportional to the work that is going with Oracle’s Healthcare Data Warehouse Foundations. We have gone through a couple of development iterations in the last few months. We’ve been busy working with development partners and customers – flying all over the place. The vision of a single, enterprise-scope data [...]
August 7th, 2010 | Posted in ORACLE BLOGS | No Comments
Hi Tom: In our data warehouse end of month process, there is one job that runs the following update statement and it took 9 hours and 21 minutes to finish: {code} UPDATE TABLE1 C SET ( POLNUM, POLREN, POLSEQ…
August 5th, 2010 | Posted in ASKTOM.ORACLE.COM | No Comments
"If you are planning any new data warehouse related projects or simply refreshing your data warehouse platform,' says Kieth Laker, "you must consider the impact that analytical connectivity will have on your system."
July 15th, 2010 | Posted in ORACLE TECHNOLOGY NETWORK | No Comments
The right time data warehousing presentation and demonstration using Oracle GoldenGate and OWB 11gR2 data warehouse operators at the recent ODTUG Kaleidoscope conference in Washington DC can be found below. It combines GoldenGate for replicating from a source to a stage system with OWB to process the changes using the dimension operator. I thought it [...]
July 13th, 2010 | Posted in ORACLE BLOGS | No Comments
The right time data warehousing presentation and demonstration using Oracle GoldenGate and OWB 11gR2 data warehouse operators at the recent ODTUG Kaleidoscope conference in Washington DC can be found below. It combines GoldenGate for replicating from a source to a stage system with OWB to process the changes using the dimension operator. I thought it [...]
July 13th, 2010 | Posted in ORACLE BLOGS | No Comments