Transcend Part 1: Mappings

Wednesday, December 1st, 2010 by Stewart Bryson

If you read the blog regularly, then you know that Rittman Mead offers a product called Transcend that is designed to interact with the Oracle Database to make some of the heavy-lifting in ETL mappings very simple. Because we recently released version 2.5 of Transcend, I thought I’d talk about some of the features I [...]

Partitioning Fact Tables, Part 1

Friday, August 13th, 2010 by Stewart Bryson

I’m dogmatic about certain aspects of data warehousing. For instance, fact tables should be range partitioned by DATE. I tell my clients all the time: you will have a very difficult time persuading me otherwise. But they always try: they argue about all the attributes that are more pervasive than DATE: customer classes, transaction types, [...]

Oracle OLAP 11g – Reporting in Excel using Simba MDX OLE-DB Provider

Wednesday, August 11th, 2010 by Venkatakrishnan J

If you had looked at my blog entry here, i would have shown a way of reporting on Oracle OLAP 11g using the newly introduced Essbase XOLAP. As mentioned there, one of the biggest advantages of using Essbase is its tight integration with Excel through Smart View. Unfortunately, in the case Oracle OLAP, the excel [...]

Realtime Data Warehouses

Thursday, April 8th, 2010 by Peter Scott

In a little over two weeks I will be giving my Real Time Data Warehousing talk at Collaborate 10 in Las Vegas. I will cover a variety of techniques and not just change data capture. However, in my opinion, CDC plays a major part in the practical implementation of a realtime data warehouse. It is [...]

Transcend and Segment-Switching

Tuesday, March 23rd, 2010 by Stewart Bryson

As you read this most recent post on the capabilities of Transcend, I’d like to pose a question to you: would you consider using Transcend in your environment if it was open-sourced? Currently, we implement Transcend as part of the Rittman Mead Rapid Deployment Framework for our clients, but have been considering opening it up [...]

Website Design & Build: tymedia.co.uk