Dear expert,
I have 1 fact table with many dimension and measures like this: (TYPE 1)
| Date | Dimension 1 | Dimension 2 | Dimesion n | TOTAL | Total A | Total A1 | Total A1-a | Total A1-b | Total A2 | Total A2-a | Total B | Total B1 | Total B1-a | Total B1-b | Total B2 | Other measures |
In detail:
TOTAL = Total A + Total B
Total A = Total A1 + Total A2
Total A1 = Total A1-a + Total A1-b
It stores data horizontally. If i change to vertical, it will be like this: (TYPE 2).
| Date | Dimension 1 | Dimension 2 | Dimension n | Level 1 | Level 2 | Level 3 | Level 4 | Value | Other measures |
| | | | TOTAL | Total A | Total A1 | Total A1-a | | |
| | | | TOTAL | Total A | Total A1 | Total A1-b | | |
| | | | TOTAL | Total A | Total A2 | Total A2-a | | |
I want to ask about the storage/performance between 2 types above. Because I am working with larger amount of data. For storing data as TYPE 1, it takes more than 20 millions rows and 2.3 GB on disk per day. If i change it into TYPE 2, does it need more space to store the data? (i didnt try). If you have experience with this, please share with me.
