Unisys and Microsoft SQL Server 2005 Speed Up the Process
Unisys and Microsoft conducted the testing at the Unisys BI Center of Excellence in Bellevue, Washington. The test methodology used was designed around real customer scenarios that required sales and marketing data to be loaded from mainframes into a SQL Server 2005 data warehouse on an ES7000 server. The mainframe data consisted of line item order data in a variety of files some with more than 100 million rows consisting of approximately 20 GB of data each. The data needed to be loaded and optimized for use with OLAP cubes. The challenge faced was updating the data warehouse in a short batch update window. Based on this scenario, the testing included key aspects of the ETL process: Reading data in from flat files, transforming and cleaning it up, formatting it uniformly, and then writing it to the target repository to be exploited.
[Read the rest of this entry...]
