Is there any difference for disk configuration for OLAP systems in comparison to OLTP ,Please suggest the consideration for disk design and RAID levels for OLAP systems to get best throughput.
I need to load files from different source. They may provide different granularity of dimensions. For example, there is a dimension table Location: LocationKey, zip, city, state, ....