Memory space acquired by cube in database

[Former Member]

Hi,

Does dimension tables & fact tables of cube reside at different places in memory?

Thanks,

prasanna n.

[FCI · Accepted solution]

Depending on the technical settings of your cube (menu Extra/Db storage parameters) the dimension tables and the fact tables may or not be stored on different tablespace (the data class you can see in the technical settings of the cube is linked to a tablespace in the table IAORA for Oracle db).

Regards,

Fred

Edited by: FCI on Apr 15, 2009 11:10 AM

[Former Member · Accepted solution]

thanks...where i can get more more information on the data clasess 7 how it is related to database memory allocation..

[FCI · Accepted solution]

Hmm, not sure to understand your concern. Data class define the place where the data is stored at disk level. Cube are not stored in memory, SQL request may be put in cache (in the same memory space through a join on the dimension tables and the fact tables).

Regards,

Fred