Which one of the following is the reason of using aggregate in dimensional model of data warehousing?
1
it helps in retrieving data from operational system
2
it takes the dimension and change its granularity
3
it stores data in one operational system
4
All of these
5
None of the above