A faster way to prepare dimensional databases
As part of a recent project I was faced with a problem. The new "proof of concept" corporate OLAP data warehouse that we were developing was starting to grow way beyond its initial specification, and the time taken to carry out daily processing would soon become difficult to explain to management. There was one clear area where the increase in processing time was becoming unsustainable: the preparation of the fact and dimensional tables in a SQL Server database that were then used by SSAS to populate the Analysis Services cube.
Tags: design