the 8GB machine is not the OLTP system, it's a server that will be used for loading source data and staging.

dimensional modeling can be achieved in both of the implementation method i described, the question is which method will perform faster.