In addition to the various data modelling techniques that need to be employed for creation of new datawarehousing solution, a lot of thought needs to be put on underlying storage model needed.
DW requirements mostly are different from OLTP/POS systems as most of the data can be ETL’ed from source systems.
Microsoft has a tool called as “Fast Track Core Calculator” that can be used as a reference before choosing the SAN vendor as it suggests number of cores needed, number of arrays, disk size & throughput (MB/sec).
Please download the same:
0 Comments.