Skip to Content
Former Member
Nov 19, 2007 at 01:02 AM

Improve data load performance


Hi Gurus,

My question is rather than line item dimension is there any other way to improve the data load performance when the dimension table size is greater than 10% of the fact table. I have a cube with five dim tables out of which one dim table size is 33% that of the fact table with 5 chars, the data model has been built and running in production. I know that for this type of problems we need to make that dim table as line item dim. Would anyone suggest any other solution to improve performance when dim table has more than 1 char and running in prod. I greatly appreciate your time and guarantee of assign points.