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.