DATA Volume

[Former Member]

Hi Gurus,

I would like to find the volume of data currently existing in an ODS and a Cube. I also would like to know what is the average size of the delta loads (Daily) from an ODS into a cube .....

Another question is how do i estimate the data volume of a non existing ODS (Means- I am trying to make this ODS and it is planned to be fed from 3 different ODS's). Answers will be rewarded...

Thank You

Southie

[Former Member · Accepted solution]

If You need data base table size look it up in DB02 (detailed analysis)

[Former Member]

Hi southei,

for ODS you can check basically 3 table, new data table, active data table and change log table. If you goto content, u find new data, active data and change log and if u click on each, u can find the respective table.

The main table u can check is active data table. In DB02 you shud be able to get the space occupied by this active data.

For cubes, if you goto transaction listschema, it will list all the fact table and dimension table names. basically there will be 2 fact table, E fact table and F-Fact table. If you check the size of these and the dimension tables, it shud give you the total size of the cube.

Hope it helped

Sriram

[Former Member]

Hi dear,

when you say 'size' do you mean 'number of entries' or DB physical siza (as byte) ?

About the first option you can do it directly in SE16 (fact tables for cube - dimension tables is not so huge - or active data tables + change logs for each ODSs), otherwise you have to check in some specific DB admin transaction (as DB02 for Oracle platform), where you can find also load average and so on...

Let me know your mail, so I can mail you some document about size estimation... (as per your second question...)

Hope it helps!

Bye,

Roberto

[Former Member]

Hi Roberto,

i know how to find the number of entries,By size i mean the physical size in GB or MB....my email is rizvin@gmail.com....i would like to get some info from your document........Thanks a lot

Southie

[Former Member]

and a forward to srirama@gmail.com

thnx

Sriram