Why Data Warehouse Dimensions Should Be Kept To A Minumum

Thursday, September 25th, 2003 by Mark Rittman

Data warehouse fact tables contain one or more measures (such as ‘volume sold’, ‘cost price’ and ‘retail price’) and one or more dimensions. When the data model is first put together, the number of dimensions is usually quite small, and centre around common business areas like organization, time and geography. As the data model is [...]

Securing Data Warehouses With OID, Advanced Security And VPD

Thursday, September 25th, 2003 by Mark Rittman

Once the domain of a small group of knowledge workers within an organization, data warehouses are increasingly becoming a critical part of an overall  I.T. infrastructure. Organizations have come to depend on the information held in data warehouses and data marts, and often the warehouse is the only source of information within an organization that [...]

Keeping Warehouse Dimensions To A Minimum

Thursday, September 25th, 2003 by Mark Rittman

Data warehouse fact tables contain one or more measures (such as ‘volume sold’, ‘cost price’ and ‘retail price’) and one or more dimensions. When the data model is first put together, the number of dimensions is usually quite small, and centre around common business areas like organization, time and geography. As the data model is [...]

OWB10g Data Quality Features

Tuesday, September 23rd, 2003 by Mark Rittman

Mark Van De Wiel and Ali El Kortobi put together a presentation for Oracleworld on the data quality features in Oracle Warehouse Builder 10g. It covers the name and address cleansing and match-merge features, the new debugging facility and the module snapshot feature. What’s particularly interesting about the new features is the match-merge facility, which allows [...]

Update to Article About Oracle Departures

Tuesday, September 23rd, 2003 by Mark Rittman

An update to the story posted on 19th July about Oracle’s Mark Jarvis and George Roberts resigning. Jon Wilkinson points out an error in Reuters description of Charles Phillips, who is described in the article as a former star software analyst at Morgan Stanley. In fact, according to Jon, “Charles Phillips (or Chuck as he [...]

Website Design & Build: tymedia.co.uk