The star schema dimensional model provides a nice balance of RAM usage and runtime performance. A single flattened table or even an extreme snowflake will produce the correct results. For typical small to medium apps any of the models will provide acceptable performance and resource usage.
In some cases a single table can provide better response time, but at the cost of significantly more RAM. It's usually not worth the tradeoff in my experience.