Efficient extraction, transformation and loading (ETL) of data into your data warehouse is a pre-requisite for successful business intelligence solutions. Oracle Warehouse Builder helps you turn data into quality information, managing the full life-cycle from data warehouse design to information acc
Other News
Trace Messages Part II: Writing to the Trace
(Andrew Novick) In the previous issue I discussed the AppSession table that I use as a way of organizing application trace lines that come from the same program. This issue is about writing trace lines in order to record information about your application. In .Net it’s been my practice to write ab
Out-of-Container EJB 3.0 Testing with Oracle Entity Test Harness
(Debu Panda) Many software projects fail to deliver a high-quality product due to a lack of testing. Often, testing is either an afterthought or gets cut back when the project delivery schedule becomes tight. Furthermore, developers think they’re responsible only for developing application modules a
SQL Server Performance Enhancement Tips
(Subhash Ramachandran) SQL Server 2000 has many features which when used wisely, will improve the performance of the queries and stored procedures considerably.
DB2 Universal Database Version 7 to Version 8 migration FAQ
This document answers some of the more Frequently Asked Questions related to DB2 UDB Version 7 to Version 8 migration.
INF: ‘OR’ Clause Prohibits the Use of Merge or Hash Algorithms
Hash and merge algorithms can be used in a join operation between two or more tables only if there is at least one qualified equality comparison between the join attributes. An OR clause disqualifies all equality comparisons between joined tables.
Datamining Apache Logs with PostgreSQL
(Robert Bernier) The hardest thing I had to learn, when I started working with SQL, was to speak English well. Data processing using a procedural or object-oriented programming language involves breaking down the entire operation into multiple steps. These functions, or methods, massage the data int
Lock Monitoring
(T.N.V.R.L.S Gupta) You can run this script on any Oracle version of database to find out the lock details. (script)
Full Text Search on SQL 2000 Part 4
(Don Schlichting) This article concentrates on using Full Text Search to query text located inside Microsoft Office documents. In previous articles, Microsoft Search was introduced as an add-on service to enable advanced text queries. Catalogs, the physical storage units for search, were created and
Bind HTML data elements to XML data islands
(Phillip Perkins) XML provides a universal medium for delivering data, and IE 5.0+ offers the functionality to quickly create data solutions. One of these functions is the ability to bind HTML elements to data sources, specifically, XML data islands. (R)