If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dimension Build seems slow

Started by SMitchell, 04 Apr 2011 12:31:25 PM

Previous topic - Next topic

SMitchell

Hello,

I have a data warehouse (Microsoft SQL Server 2008 R2) with a primary file group and a different staging file group. I'm loading a dimension (about 380,000 records) from a staging table it's taking about 19 minutes to process just this one dimension. The dimension is marked for a full refresh.

I've removed the clustered primary key from the dimension to see if that would help with the load but that really didn't do much.

It seesm to take about 3 minutes for 50,000 records. I'm not sure if this is a normal processing time for a dimension build of this size or if this is slow. I was hoping to get it load much faster.