Even if you combined both cases you would not get 3 guilds at 100, combining the 2 would give 4 guilds at 100.
So let's say you have 6.5M rows, so on a 32-bit machine, this IDENTITY column will take more than 2G memory to hold the data. Cast 2 of increasing the base level when the craft limitation is applied, but leaving the limitation at 40 is 80 + 20 100 for 2 crafts (20 x 2 40 for craft skill limits), rest at 80. Marco Russo If you have high cardinality, such as an IDENTITY column, that pretty much makes the column not compressable.
Is there someone that can explain better what's happening, so that I can understand how to anticipate possible memory problems - and in general how to optimize data for a PowerPivot model? Marco At this point, my understanding is that the cardinality of attributes you are importing (especially in the fact table, when you have millions of rows) is very important in determining the size of the file and (more important) the memory required to process data.
Just before throwing this error, the Excel process was using 650Mb of Commit Size (read on task manager) and there was plenty of free RAM (more than 1Gb). Thus, my understanding is that the cardinality of attributes is very important for memory usage while importing data. And, in this mode, boom, as soon as all the rows are imported, the PowerPivot generate this error: Memory error: Allocation failure : Not enough storage is available to process this command. But, at a certain point, trying to understand a particular behavior, I included a column that is an identity key of the fact table (I know, Kimball's theory don't require it, but we often use it for maintenance purposes). Well, everything worked well using a large dimension with 254K rows. I was looking for differences between normalizing dimensions in different PowerPivot tables or denormalizing them in a single table (joining all dimensions I want in a single query).
Scenario: I have a 6.5 millions rows fact table in a data mart and I wanted to load it in PowerPivot. I catched an interesting case for memory error. In this Video I will show you How To Fix OUT OF MEMORY Error In Adobe AFTER EFFECTS 2021, Unable To Allocate Memory Error in Adobe After Effects cc 2021, Aft.