i have 5 dim tables with ~ 1 million rows
also 2 fact tables with 500 Million rows
there are joins with those dims and facts - of course aggragations and calculations .
what should be an optimal hardware ?
do i need more than one server ? how much memory ? cpu ? disks?
would you suggest 1um and 1 pm for later growth? and configure : multiple and seperate?
please suggest an option that we can grow with it - add pm's later on